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.

"Adam_needs_help" wrote:

> 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.

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.

"Justin" wrote:

> Use a query to export the data instead of the table and create the field
> headings you want.
>
> "Adam_needs_help" wrote:
>
> > 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.

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.

--
--Roger Carlson
MS Access MVP
www.rogersaccesslibrary.com
http://rogersaccessblog.blogspot.com/


"Adam_needs_help" <(E-Mail Removed)> wrote in message
news:3A06D5A7-F273-4664-9F2A-(E-Mail Removed)...
>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.
>
> "Justin" wrote:
>
>> Use a query to export the data instead of the table and create the field
>> headings you want.
>>
>> "Adam_needs_help" wrote:
>>
>> > 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.