Export To Excel Is In Version 5.00 Format Not 97

[kevsim]

Using the code below, I transfer a Query to Excel, except it is in Excel 5.0 format, How can I change this for output of Excel 97 or 2000.
I would appreciate any assistance.

DoCmd.OutputTo acQuery, "Q_FinalData", "MicrosoftExcel(*.xls)", "C:\My Documents\WagesTemplate.xls", True
Kevsim

 

[jfgambit]

Try:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryName",FilePath