Excel 2007 vba Is there a way (subroutine or API calls) to get the version of Excel that is running?

[rick]

I have done some work with the ribbon as well as some 2007-only vba
constructs and need to determine the level of Excel that opened the workbook
so I may set the menu bar and command bars properly.

Something like the OBtn/resources/about.

Thanks.

...rick

 

[Ron de Bruin]

Use

If Val(Application.Version) < 12 Then
'97-2003
Else
'2007
End If

See also
http://www.rondebruin.nl/compatiblemenu.htm