VBA test for finding Excel version?

[9tanstaafl9]

Is there a way in vba to test to see what version of Excel is being used?
My macro would crash if their data would exceed the 65K row limit in Excel 2003. I have a message that pops up if they do that, and it handles the problem just fine, but if they are ALREADY using Excel 2007 (or whatever comes later) I don't want the message to appear.

How do I test?

Jennifer

 

[gauntletxg]

Application.Version

12.0 = Excel 2k7

 

[9tanstaafl9]

Application.Version

12.0 = Excel 2k7

Thank you. So how would I use that exactly? (Still on my first project here...)

Would this be right to test for Excel 2007 or later?

if application.version >= 12.0 then 
     'code goes here
end if

Thanks. I'd test it myself but I'm using 2003.

 

[gauntletxg]

It depends on what you want to do, but there's really no need to check if the version is greater than 12.0. If you only want your code to run if the user has 2007, just check for = 12.0.

 

[9tanstaafl9]

Ok, but when I enter 12.0 VBA changes the code to read 12# Is that what is supposed to happen?

I'm actually trying to make sure they have 2007 OR LATER so I don't have to redo the code if they upgrade someday. I suppose testing for if what they are running = Excel 2003 instead would work. Do you happen to know the version number for 2003?

 

[stanleydgromjr]

9tanstaafl9,

Sub ReturnExcelVersion()
    If Application.Version = "12.0" Then
        MsgBox "You are using Excel 2007."
    ElseIf Application.Version = "11.0" Then
        MsgBox "You are using Excel 2003."
    ElseIf Application.Version = "10.0" Then
        MsgBox "You are using Excel 2002."
    ElseIf Application.Version = "9.0" Then
        MsgBox "You are using Excel 2000."
    ElseIf Application.Version = "8.0" Then
        MsgBox "You are using Excel 97."
    ElseIf Application.Version = "7.0" Then
        MsgBox "You are using Excel 95."
    End If
End Sub

Have a great day,
Stan

 

[gauntletxg]

11.0

 

[9tanstaafl9]

Thank you both. I've got it now. Sorry if this was a dumb one, but the search terms were too generic for me to find anything (or my searches were anyway). I appreciate the help. --Jennifer

 

[G12]

Perfect. This is exactly what I needed to see also. Solved different problem and, for the record, if someone else looks back at this Excel 2010 is ?Application.Version = 14.0

 

[Ten98]

What happened to version 13???? Another MS conspiracy?!?!!?