Export to Excel

J

J Shrimps, Jr.

Got a bunch (36) of queries that export
to Excel. Summarizing spreadsheets
(not created from Acccess) link to these
exported queries.
When Access exports a query/table,
the first sheet in the spreadsheet
is always the name
of the query/table.
Have an Excel macro that opens each
spreadsheet, renames the first sheet
(there's only one sheet, the spreadsheet
is written over every time with fresh data),
and closes the spreadsheet.
Is there a way to name the first worksheet
when you export to Excel in Access?
 
K

Ken Snell [MVP]

Not as part of the export, no.

You'd need to either use a different name for the query (create a copy of
the query with the new name and export the copy of the query -- which can be
done via VBA programming), or change the worksheet name after the export is
done (also can be done via VBA programming).
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Export Format not avaiable 1
Export to excel has character limit 3
Query Export Issue 5
Is there a way to turn off the prompts of a make table query? 3
Export to Excel 3
Exporting 2 queries into 1 excel spreadsheet 1
Export Pivot Table to Excel 1

Top