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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top