HELP!! Export a Spreadsheet in Access to a xls file

[ankash]

Hi all,



I would like export a spreadsheet in Access to a excel file. I used Office.Spreadsheet 11.0.

However, the following code only exports the spreadsheet into a xml file which is not I want!
ALL I want is xls file type instead of XML!

SpreadSht.Export strfilename, ssExportActionOpenInExcel, ssExportAsAppropriate



Please kindly help on this problem. Many thanks.

[GinaWhipp]

Use the TransferSpreadsheet method...

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "YourTable",
"C:\YourPath", True

...I am a bit confused by your Office version, is it 2002? Because I don't know Office 11 for a PC.

[ankash]

Spreadsheet 11.0 is the OLE class. I use office 03

[GinaWhipp]

Okay, cause in the Header it says Access 2002, so I was a bit confused.