Function Code for Version of Excel (2003, 2007, etc.)

[DBrenner]

Obviously the function code increase in 2007 has helped us all out quite a bit. Except for those living in the dark ages of 2003 that is.

These are the people that don't even know they are running 2003.

Unfortunately I run into this quite often and the first question these people ask me is, "How do I know which version of excel I have?"

Is there a simple function code that will tell which version of excel the end user is using so I can incorporate it into the users sheet so they can easily see that the sheet won't work unless they upgrade to 2007?

 

[Ruddles]

Is VBA acceptable?

Application.Version will return the software version number.

You could incorporate this into a UDF or the Workbook_Open event handler.

 

[Lidsavr]

I was going to recommend the same code as Ruddles, however the Application.Version code only returns the version number. It sounds as if your users may not know which version applies to the Excel program (e.g., 12.0 = Excel 2007. I was going to suggest the following code:

Sub App_Excel_Version()
    MsgBox "This version of Microsoft Excel is: " & _
        Application.Version & Chr(13) & Chr(13) & _
        "Version 13.0 - Excel 2010" & Chr(13) & _
        "Version 12.0 - Excel 2007" & Chr(13) & _
        "Version 11.0 - Excel 2003" & Chr(13) & _
        "Version 10.0 - Excel 2002 (XP)"

NOTE: The version numbers above my not be accurate. I am going off of memory. You may have to change the version numbers accordingly.
Regards,

Charles

 

[DBrenner]

The problem with vba is that these particular people usually don't have macro enabled... And you can forget about asking them to enable it! Lol

 

[Ruddles]

Help > About.