Determine version of Excel in VBA
John
I'm afraid I don't know the version number for 2007 but 2003 is 11.0 so
something like this
If Application.Version = 11 Then
'Excel2003
'do 2003 macro
MsgBox Application.Version
Else
'check for 2007 version number
'do 2007 things
End If
Mike
"John" wrote:
I'd like to my macro to execute a certain sub if the user is using Excel
2003, and execute another sub if the user is using Excel 2007, both called
from the same shortcut key. Possible?
|