Problem Exporting to xls File

  • Thread starter Thread starter John Lane
  • Start date Start date
J

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.
 
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?
 
Are you exporting to EXCEL 2007? If yes, change "acSpreadsheetTypeExcel3" to
"acSpreadsheetTypeExcel12".
 
Help file for TransferSpreadsheet explains the various intrinsic constants
and their values/use.
 
Back
Top