EXCEL VERSION

Dweeb458

Board Regular
Joined
Nov 15, 2005
Messages
52
Is there a way to find out what version of excel is being used by a user who opens a workbook. (IE: EXCEL97 EXCEL2000 EXCEL2002 EXCEL2003). I'd like to place something in the 'Workbook Open' to identify what version of excel the user is using.

The only code I found was this:

MsgBox "Welcome to Microsoft Excel version " & _
Application.Version & " running on " & _
Application.OperatingSystem & "!"

This only tells me for example: Version 10.0
I could use a history lesson on the Versions if I'm thinking about this all wrong. Can anybody help? :wink:
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
XL8 - Excel 97
XL9 - Excel2000
XL10 - Excel2002 (ie from Office XP)
XL11 - Excel2003

(I believe)
 

Dweeb458

Board Regular
Joined
Nov 15, 2005
Messages
52
Thank you Parsnip.

And Thank you to all members whom posted codes. I've learned quite a bit from this site. Thankyou Thankyou Thankyou. :biggrin:
 

Watch MrExcel Video

Forum statistics

Threads
1,118,812
Messages
5,574,457
Members
412,595
Latest member
slim313
Top