Create Excel 2003 file from Acc2007/2010

[marlan]

Hi,

I was hoping there would be a generic solution, without version checking...
I tried

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "DummyTable", strFilePath

to just create the file using generic code - it works, but takes double time.

I guess I'll have to use Application.Version to check What version is running...
Thanks alot!

 

[vbaInet]

If you SaveAs without the FileFormat and include the correct extension in the path, it will save the file in the older format. But you need to be explicit in the file path and extension you give it. For example, the below will work for any version:

xlWBk.SaveAs "C:\Users\marlan\Spreadsheet[COLOR=Red].xls[/COLOR]"

That is the crucial part.