View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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?