Export an Access 2003 query using a macro to Excel 2003

[Gucci2006]

I am attempting to write a macro that will export a query to Excel 2003. The Excel workbook contains numerous sheets. How do I write the path (in the output macro box)so that the correct sheet will be updated with the exported information.

 

[PHV]

the correct sheet will be updated
I'd use Ms-Query (QueryTables objects in Excel) instead ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[JerryKlmns]

Exporting to an existing excel file, a table/query that has the same name as a sheet, then new data is written over old. The process will fail if you have active filters. The worst is that if new data is 15 rows and old >15 you 'll get the 15 new at the top excel rows and the rest of the old ones!