acSpreadsheetTypeExcel

K

ken

I'd like to import an Excel 2000 spreadsheet using the
TransferSpreadsheet command. Which acSpreadsheetTypeExcel
should I specify?

Ken
 
B

BerHav

Hi Ken,

Excel 3 : acSpreadsheetTypeExcel3
Excel 95 : acSpreadsheetTypeExcel7
Excel 97 : acSpreadsheetTypeExcel8
Excel 2000 : acSpreadsheetTypeExcel9 (Default Value!)
Excel 2002 : acSpreadsheetTypeExcel10
Excel 2003 : acSpreadsheetTypeExcel11

As Type 9 is the default value you don't need to mention it.


Regards,
Bernd
 
Top