Specifiy Tab on Ouput to Excel

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
 
A

aMack

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

Awesome - easy - I like it.

Thanks
 
Top