header for excel spreadsheet

[crowegreg]

Are you able to create a header record when exporting a query into a spreadsheet? Thank you in advance!!

[June7]

How are you doing the export? The export wizard will take the table/query fields as the header row for the spreadsheet.

[crowegreg]

Using this VBA code,
DoCmd.TransferSpreadsheet acExport, 8, "qryExportMSR", "c:\production\QOH-Title.xls", True, ""

[June7]

The True argument tells the code to send the field names as the first row. Is that not working?

[crowegreg]

Yes, the field names are working properly. I'm trying to place a report title and date of printing before the field names and data. That's why I was checking to see if their is a way to create a header for the spreadsheet.

[June7]

Not with the wizard or TransferSpreadsheet methods. You could have additional VBA code to modify the spreadsheet once it is created to insert rows and text into cells.

[crowegreg]

OK. could you point me in that direction?

[June7]

First declare workbook and worksheet objects then insert rows and insert values to cells. Start with:
http://www.java2s.com/Code/VBA-Excel...ctvariable.htm
http://www.anthony-vba.kefra.com/vba/vbabasic2.htm
http://bytes.com/topic/access/answer...ccess-using-vb

Attempt code and post for analysis if you have issue.

[crowegreg]

Thanks. I'll look at these links tonight.