You can use code like the following:

Dim Ver As Long
Ver = CLng(Application.Version)
If Ver = 12 Then
' Excel 2007 or later
Else
' Excel 2003 or earlier
End If

Note, though, that any code the uses objects or methods that are new
to Excel 2007 will fail to compile and run in 2003. You'll get
compiler errors on those methods, even if you never execute them in
2003 and earlier.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



On Tue, 12 May 2009 07:11:57 -0500, "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?