Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 vba Is there a way (subroutine or API calls) to get the version of Excel that is running?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 vba Is there a way (subroutine or API calls) to get the version of Excel that is running?
Use
If Val(Application.Version) < 12 Then '97-2003 Else '2007 End If See also http://www.rondebruin.nl/compatiblemenu.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "rick" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 vba Is there a way (subroutine or API calls) to get the version of Excel that is running?
Ron de Bruin;478856 Wrote: 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) -- Regards Ron de Bruin 'Ron's Excel Tips' (http://www.rondebruin.nl/tips.htm) "rick" wrote in message ... 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 Hello Rick, If you need more detail about the version, including major and minor releases, have a look at this 'How to determine which 32-bit Windows version is being used' (http://support.microsoft.com/kb/189249). -- Leith Ross Sincerely, Leith Ross 'The Code Cage' (http://www.thecodecage.com/) ------------------------------------------------------------------------ Leith Ross's Profile: http://www.thecodecage.com/forumz/member.php?userid=75 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=132072 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I save an Excel 97-2003 version or 2007 version for Mac 200 | Excel Discussion (Misc queries) | |||
Running an excel sheet which uses RTD calls as a service? | Excel Programming | |||
Subroutine calls between workbooks and object references | Excel Programming | |||
OnAction calls to subroutine | Excel Programming | |||
VB code needed for running newer excel version macros in older excel versions | Excel Programming |