Transferspreadsheet Macro

[rneaul]

Is there a way to change the "caption" on the resulting excel spreadsheet?

The query name that I am exporting is lookup summary_mth data. Rather than
having all that as the tab name, I would like to have it called monthly
summary.

I don't want to change the name of the query because I would then have to
change numerous others that use this information.

Thanks
rneaul

 

[rneaul]

Follow-up request.

I would also like to have the excel spreadsheet set up to auto filter.

 

[Jim/Chris]

What I do is export to a hidden sheet in the Excel workbook
and reference all the data in the visible sheet. That way
I can have all of my formatting and bells and whistles on
the first sheet...

Jim