Transferspreadsheet Macro

  • Thread starter Thread starter rneaul
  • Start date Start date
R

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
 
Follow-up request.

I would also like to have the excel spreadsheet set up to auto filter.
 
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
 
Back
Top