Thread: Rename worksheets in Excel file exported from Access

Hi All,

I've created a simple macro that contains "Transfer Spreadsheet" to directory:
c:\myfiles\NewFile.xls

I'm using export to export 5 different queries into the new file, this all works fine but example the first query name is qryGrandTotalsForYear then this comes across in excel on the tab name. Is there a way I can give it a name prior or during the export?

I would want qryGrandTotalsForYear to be Yearly Grand Totals.

Thanks in advance for any suggestions here.

Hi RR,

This is a macro in access that uses "Transfer Spreadsheet" feature to take query results and put them into an excel file.

Once it's in excel it automatically puts the access query name on the tab/worksheet...this is what I would like to know if I am able to change when its putting into excel.

Is this helpful. Look at the attached.