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

R

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
 
L

Leith Ross

Ron said:
Use

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

See also
'Dealing with Ribbons and Menus - Avoiding Two Versions
(http://www.rondebruin.nl/compatiblemenu.htm)

Hello Rick,

If you need more detail about the version, including major and mino
releases, have a look at this 'How to determine which 32-bit Window
version is being used' (http://support.microsoft.com/kb/189249)

--
Leith Ros

Sincerely,
Leith Ross

'The Code Cage' (http://www.thecodecage.com/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top