acSpreadsheetTypeExcel

J

jaydh

in VBA you get import or export options for spreadsheets - in 2003 it gives
options such as 'acSpreadsheetTypeExcel5' whereas in v97 - it would just give
the version number. What is the equivalent spreadsheet type in 2003 for
importing v97 spreadsheets?
 
G

Gord Dibben

Myrna

Between version 5.0 there were versions 7.0 and 7.0a which were known as Excel
95

Excel 97 is version 8

No answer from me for the OP's question.


Gord
 
M

Myrna Larson

Thanks for jogging my memory. I know that XL2003 is v 11, and counting
backwards, I saw I was "off by 1". I forgot about XL95.
 

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

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
How to make repeating drop-down lists? 2
Add-Ins for Outlook (Mac) ? 0
Excel does not accept text format! 0
Modern equivalent of Autotext in Word? 0
Excel And Notepad 3
Excel to Word 1
Import Images into cells from a file without using VBA or Macro. Can it be done ? 1

Top