OutputTo Action vs Method

[bobfin]

I have to create an Excel spreadsheet from an Access table using a macro. The filename is constructed from textbox values in a form. In a custom function, I use DoCmd.OutputTo and specify acFormatXLS as the OutputFormat. But the resultant spreadsheet is an older version of Excel. I need the Excel 97-2003 format. This can be specified in the OutputTo action, but not in the method. Is there a way to generate the correct version?

 

[llkhoutx]

Check the argument for the TransferSpreadsheet method. You'll be surprised at the number of formats which can be exported.

 

[bobfin]

That worked. The other command let me specify acSpreadsheetTypeExcel9 to get the correct Excel version. Thanks.