TransferSpreadsheet question

[Ken Warthen]

I'm using the TransferSpreadsheet method to import an Excel spreadsheet into
an Access 2007 table. I've set the SpreadsheetType parameter to
acSpreadsheetTypeExcel9. This works when the spreadsheet is a .xls file, but
the spreadsheet I'm importing is a .xlsm file. To make the code work I open
the .xlsm file in Excel and then do a SaveAs where I can change the file type
to .xls. This is not really an acceptable solution for end users of the
application. Is there a way to import spreadsheets in the .xlsm format?

Ken

 

[Dirk Goldgar]

I'm using the TransferSpreadsheet method to import an Excel spreadsheet
into
an Access 2007 table. I've set the SpreadsheetType parameter to
acSpreadsheetTypeExcel9. This works when the spreadsheet is a .xls file,
but
the spreadsheet I'm importing is a .xlsm file. To make the code work I
open
the .xlsm file in Excel and then do a SaveAs where I can change the file
type
to .xls. This is not really an acceptable solution for end users of the
application. Is there a way to import spreadsheets in the .xlsm format?

Try acSpreadsheetTypeExcel12 for the SpreadsheetType. If that isn't
defined, use the numeric value 9.

 

[Ken Warthen]

Dirk,

Thanks for the help. That worked fine, of course.

Ken