Problem Exporting to xls File

[John Lane]

I'm running Access 2007 on Vista, and in my program I have the statement:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel3,
"tmpGLA_Crosstab", Filename

and I am getting the message "Could not find ISAM file", however I can
export the table to an xls file with the ribbon Excel icon. Help prattles on
about the Registery and such, but the dll must be on the system beacsue the
ribon icon works. Do I need to add another library to the References list?
Which one? Thanks.

 

[John Lane]

I figured it out. You have to use the "8" version option in the
TransferSpreadsheet command for it to work. Without looking at the Registry,
how in the world would a "normal" person ever figure it out?

 

[Ken Snell [MVP]]

Are you exporting to EXCEL 2007? If yes, change "acSpreadsheetTypeExcel3" to
"acSpreadsheetTypeExcel12".

 

[Ken Snell [MVP]]

Help file for TransferSpreadsheet explains the various intrinsic constants
and their values/use.