Excel Version

[Don Guillett]

see if this helps. Otherwise, probably not.
Sub whatversion()
msgbox ActiveWorkbook.FileFormat
End Sub

 

[1 of 1]

Is there any way to find out what version of Excel a spreadsheet was
originally created with?

 

[Dave Peterson]

It corresponds to the xl constant: xlWorkbookNormal

So it doesn't help too much.

 

[Don Guillett]

It should indicate that the version in xl97, or later

 

[Bob Phillips]

That tells you it is Excel 2000 or later.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[1 of 1]

Thanks.
Does '-4143' in a message box with an 'OK' command button mean anything?