- Joined
- Sep 18, 2006
- Messages
- 1
- Reaction score
- 0
Current Situation: 10 queries that are pulling for different places. The queries all require that I enter a begining date and ending date which is the same for all queries. After I get the output, I have been manually copying the outputs into one excel file.
I would like to simplify this so that it at least runs all the queries for me and combines the outputs
I have tried making a Macro to run the queries and output to 10 different excel files by making a new macro and have ten lines of OutputTo and in each line I have the following:
Object Type: Query
Object Name: (Query Name 1-10, different for each action)
Output Format: Microsoft Excel 97-2003 (*.xls)
Ouput File: c:\combine\(query number).xls
Auto Start: No
Template File: (blank)
Encoding: (blank)
This makes the Excel files I need, but I would like to have them combined, and if possible it would be nice if it only asked me once for the Start Date and End Date, but it asked me 10 times.
Any suggestions?
I would like to simplify this so that it at least runs all the queries for me and combines the outputs
I have tried making a Macro to run the queries and output to 10 different excel files by making a new macro and have ten lines of OutputTo and in each line I have the following:
Object Type: Query
Object Name: (Query Name 1-10, different for each action)
Output Format: Microsoft Excel 97-2003 (*.xls)
Ouput File: c:\combine\(query number).xls
Auto Start: No
Template File: (blank)
Encoding: (blank)
This makes the Excel files I need, but I would like to have them combined, and if possible it would be nice if it only asked me once for the Start Date and End Date, but it asked me 10 times.
Any suggestions?