export to excel

G

giorgio

I use DoCmd.OutputTo acOutputReport, "name", acFormatXLS to export to excel.
How can i put the version of excel (2000, xp or 2003)?
It export in excel 5.0/95.

thanks
 
B

BerHav

Hi,

with the OutputTo command you can't specify the Excel file format, try instead the TransferSpreadsheet method.
 
Top