Report to Excel but including header.

[bbarclay]

Probably been asked a million times. I'm sure it can be done. Does anyone know how? I have a report that has a header Well Head Names Update.



When I click the button export to excel, it would be nice if this header was on the excel spreadsheet kind of how it looks on the report. Does anyone know how to do this? I created the export button using the wizard and linked it to the report that needs exported.


Thanks



Brandon

[June7]

I think previous versions of Access did that. I seem to remember report exports to Excel that were a mess with headers and footers. I think you will have to modify the worksheet to insert the header rows and text. This can be automated with VBA code.