Sending report to Excel 2002

  • Thread starter Thread starter DonB
  • Start date Start date
D

DonB

Posted in "Reports" but didn't get a response.

I am exporting a report via VBA to Excel. Works fine
except I cannot set it to the correct excel format. It
exports to Excel 5.0 format, I want the spreadsheet in
Excel 2002.

My only solution is to leave the "format" option blank
which brings up as save as dialog. This will get it to
the proper Excel version, but I need this done in code.

What is the string for acFormatXLS that will save this
report to Excel 2002?

DoCmd.OutputTo acReport, txtRPTName, acformatxls,
txtExcelFileName

Thanks
 
Hi Don,

I wish I knew. It ought to be "MicrosoftExcelBiff8(*.xls)"; this is what
appears if you create an OutputTo macro exporting to Excel 97-2002
format and convert it into a VBA module; but it doesn't work when i try
it.
 
Back
Top