Changing Header exported to Excel

  • Thread starter Thread starter Adam_needs_help
  • Start date Start date
A

Adam_needs_help

I am exporting tables to excel and it automatically makes the header in the
excel file the table name. I want to be able to add something to that
header.

For example if the table name is "ABC" I want the header in excel to be "ABC
Delicious"

I want this to happen automatically (so it can be part of a macro) as I am
exporting many tables on a daily basis.

Thanks.
 
Use a query to export the data instead of the table and create the field
headings you want.
 
I don't think I was clear. I am talking about sheet header, not column
headings. So I want to be able to change the sheet header. Hopefully that
makes sense.
 
Actually, the same way. Create a query named whatever you want the sheet
tab to be named. Export the query instead of the table. You can then
reference the sheet tab in your header.
 
Back
Top