Exporting into different Worksheet

[MJCoxy]

In my code I have exported a query into an Excel file I then open the file and format the exported data. I now want to export another query into a separate worksheet within the same excel file. Does anyone know if this is possible?

 

[yesilkalem]

I have a same problem . did you solve it ?

 

[MJCoxy]

You just need to export the Query or Table to the same file you created first and Access will insert another worksheet with that data calling the worksheet the same name as the query/table as usual. Make sure the new table or query hasn't got the same name as the first one you exported.