Specifiy Tab on Ouput to Excel

  • Thread starter Thread starter aMack
  • Start date Start date
A

aMack

I have a customer requesting 2 separate reports be sent on 1 Excel file.

I am running 2 Macros to generate 2 different excel files.

Can I direct the 2nd macro to output the query data into a specific tab on
an existing excel file?

thanks
 
That means Excel or Access will output to a new tab on the same file?

Awesome - easy - I like it.

Thanks
 
Back
Top