acSpreadsheetTypeExcel

  • Thread starter Thread starter ken
  • Start date Start date
K

ken

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

Ken
 
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
 
Back
Top