Exporting query results to different sheets in one excel book

[pspring1]

I am want the results of 3 queries in Access to be exported into the same spreadhseet on 3 different sheets in Excel. I have set up a macro that can run the queries
and then output them to this specific excel file but if i want to get the other two one it just replaces the whole file with the new query. However, I want the 2nd one to go in the same file on a new sheet and the same with the third. Is there a way I can do this using macro's? Thanks for your help!

 

[HitechUser]

pspring1,

Here is some info...

Tek Tips

Also you can use the macro convert and convert it to VBA. Then use the code from above.

Also search this site...

I hopd this helps...