Hi
Is there anyway i can set up a macro to export 2 different Access queries to the same excel workbook?
When i run the 2nd export it tells me the file already exists and i need to replace it. Obviously replacing it will wipe out the data from the 1st Export.
I want the 2 exports in different tabs.
I am exporting to 97-2003 excel so not sure if this is causing the issue.
Would be really grateful for some help.
Thanks
Mike