I was hired at my company about 2 months ago, and I am trying to automate
monthly re****ts that have been created in Access 2007. In the past,
everything was done manually. I have already automated up to the point
that
the main re****ts have parameters and output nicely rather than having to
go
into SQL view and change the code every time the re****ts are run.
Now my problem is that most clients have 2 or 3 completely different
queries
included in the monthly Excel workbooks we send to them (using Excel 2007,
but re****ts are saved as 97-03 to avoid compatability issues with
clients).
I would like to use a macro to open (in this example) 3 different queries
and
output to 3 tabs in the same Excel workbook, but can't get the OutputTo
function to output multiple queries.
Help! Figuring out how to do this will literally cut hours off of the
re****ting process I have to go through each month!
Thank you! :-)
