I have an access db that builds and exports multiple spread sheets to a template.
DoCmd.TransferSpreadsheet acExport, 8, strtablename, "\\templates\output\" & strfilename, True, "TransactionInformation!b4:I4"
The True/False is supposed to designate whether to use headers, but in regardless of choice, the headers from the table exported is placed into the spread sheet.
Is there a way around it so that only the data, no headers, are exported to the spreadsheet?
(my co-worker found on msdn that the headers will always be exported, regardless of true/false.... figures)