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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export table to txt file with a variable filename 0
PowerPoint Change/update links to new source (PPT with charts & objects linked to Excel) 1
Have a Query Transfer to a Specified Tab in Excel 1
Excel On Error Resume Next 2
Output to specific Excel worksheet 3
How to Create Multiple Sheets in an Output File 1
Export from MS Access 2007 to Quickbooks IIF - How can I create a tabdelimited text file from Access 2
Excel TWO Instances of Excel One watching Other 3

Top