Remove date and time from Access -> Excel export

[odonnell]

I have some vba exporting a report to excel, the code is

DoCmd.OutputTo acOutputReport, "Projects", acFormatXLS, _
"file path\data.xls",

This works fine, however when the sheet is open the headers are in row 2. the date and time of the export is in row 1.
How can I remove the date/time in the export process as this sheet is to be connected to another workbook to auto refresh and I need the headers in the 1st row?

Thanks guys

 

[ranman256]

odd, try
docmd.transferspreadsheet
(headers are always in row 1)

 

[odonnell]

Thanks for the info, I have tried this but no luck, i get an error error 3011 that it cant find my "Projects" report. maybe it doesnt work with reports??