acFormatXLS in DoCmd.OutputTo

[fulltime]

Hi all,

To export a file to MS excel from my form, i used the command

DoCmd.OutputTo acOutputQuery, langName & partName, acFormatXLS, exportPath, False

however, i realised that the format of the excel spreadsheet (excel version 5.0/95) that i have exported is slightly different from the format of the spreadsheet if i had exported by clikcing on FILE, EXPORT...

how can i specify the excel version for the exported file? i wan it to be in the latest excel version else i am unable to perform some of the marcos i have written in the latest excel format?

Thks FT

 

[fulltime]

anbody knows?

 

[pbaldy]

DoCmd.TransferSpreadsheet allows more flexibility in specifying the Excel version.