| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel version
Hello,
I am trying to identify what version of Excel is install on a system? Is there an environment variable or a Reg key that would give me this information? Thank you. Eric |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel version
Application.Version
will return 11 for 2003, 12 for 2007 environ variables i know of for your reference: ALLUSERSPROFILE APPDATA CommonProgramFiles COMPUTERNAME ComSpec FP_NO_HOST_CHECK HOMEDRIVE HOMEPATH LOGONSERVER NUMBER_OF_PROCESSORS OS Path PATHEXT PROCESSOR_ARCHITECTURE PROCESSOR_IDENTIFIER PROCESSOR_LEVEL PROCESSOR_REVISION ProgramFiles SESSIONNAME SystemDrive SystemRoot TEMP TMP USERDOMAIN USERNAME USERPROFILE WecVersionForRosebud.828 windir -- Gary "Eric" wrote in message ... Hello, I am trying to identify what version of Excel is install on a system? Is there an environment variable or a Reg key that would give me this information? Thank you. Eric |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel version
Hi Gary,
Anything that would work outside Excel? Eric "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... Application.Version will return 11 for 2003, 12 for 2007 environ variables i know of for your reference: ALLUSERSPROFILE APPDATA CommonProgramFiles COMPUTERNAME ComSpec FP_NO_HOST_CHECK HOMEDRIVE HOMEPATH LOGONSERVER NUMBER_OF_PROCESSORS OS Path PATHEXT PROCESSOR_ARCHITECTURE PROCESSOR_IDENTIFIER PROCESSOR_LEVEL PROCESSOR_REVISION ProgramFiles SESSIONNAME SystemDrive SystemRoot TEMP TMP USERDOMAIN USERNAME USERPROFILE WecVersionForRosebud.828 windir -- Gary "Eric" wrote in message ... Hello, I am trying to identify what version of Excel is install on a system? Is there an environment variable or a Reg key that would give me this information? Thank you. Eric |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel version
someone else will have to answer that one, sorry.
-- Gary "Eric" wrote in message ... Hi Gary, Anything that would work outside Excel? Eric "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... Application.Version will return 11 for 2003, 12 for 2007 environ variables i know of for your reference: ALLUSERSPROFILE APPDATA CommonProgramFiles COMPUTERNAME ComSpec FP_NO_HOST_CHECK HOMEDRIVE HOMEPATH LOGONSERVER NUMBER_OF_PROCESSORS OS Path PATHEXT PROCESSOR_ARCHITECTURE PROCESSOR_IDENTIFIER PROCESSOR_LEVEL PROCESSOR_REVISION ProgramFiles SESSIONNAME SystemDrive SystemRoot TEMP TMP USERDOMAIN USERNAME USERPROFILE WecVersionForRosebud.828 windir -- Gary "Eric" wrote in message ... Hello, I am trying to identify what version of Excel is install on a system? Is there an environment variable or a Reg key that would give me this information? Thank you. Eric |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel version
Have a look in [HKEY_CLASSES_ROOT\Excel.Application\CurVer]
That might be enough to identify your version. Greg |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel version
Eric,
I have these 2 keys, as I have 2 versions of Office installed: HKEY_CLASSES_ROOT\Excel.Application.9 HKEY_CLASSES_ROOT\Excel.Application.10 NickHK "Eric" wrote in message ... Hi Gary, Anything that would work outside Excel? Eric "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... Application.Version will return 11 for 2003, 12 for 2007 environ variables i know of for your reference: ALLUSERSPROFILE APPDATA CommonProgramFiles COMPUTERNAME ComSpec FP_NO_HOST_CHECK HOMEDRIVE HOMEPATH LOGONSERVER NUMBER_OF_PROCESSORS OS Path PATHEXT PROCESSOR_ARCHITECTURE PROCESSOR_IDENTIFIER PROCESSOR_LEVEL PROCESSOR_REVISION ProgramFiles SESSIONNAME SystemDrive SystemRoot TEMP TMP USERDOMAIN USERNAME USERPROFILE WecVersionForRosebud.828 windir -- Gary "Eric" wrote in message ... Hello, I am trying to identify what version of Excel is install on a system? Is there an environment variable or a Reg key that would give me this information? Thank you. Eric |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel version
My concern with registry entries in general is are they removed if the
product is uninstalled? I think Office itself looks to the HKLM keys such as HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0. -- Jim "NickHK" wrote in message ... | Eric, | I have these 2 keys, as I have 2 versions of Office installed: | | HKEY_CLASSES_ROOT\Excel.Application.9 | HKEY_CLASSES_ROOT\Excel.Application.10 | | NickHK | | "Eric" wrote in message | ... | Hi Gary, | | Anything that would work outside Excel? | | Eric | | "Gary Keramidas" <GKeramidasATmsn.com wrote in message | ... | Application.Version | will return 11 for 2003, 12 for 2007 | | environ variables i know of for your reference: | | ALLUSERSPROFILE | APPDATA | CommonProgramFiles | COMPUTERNAME | ComSpec | FP_NO_HOST_CHECK | HOMEDRIVE | HOMEPATH | LOGONSERVER | NUMBER_OF_PROCESSORS | OS | Path | PATHEXT | PROCESSOR_ARCHITECTURE | PROCESSOR_IDENTIFIER | PROCESSOR_LEVEL | PROCESSOR_REVISION | ProgramFiles | SESSIONNAME | SystemDrive | SystemRoot | TEMP | TMP | USERDOMAIN | USERNAME | USERPROFILE | WecVersionForRosebud.828 | windir | | | -- | | | Gary | | | "Eric" wrote in message | ... | Hello, | | I am trying to identify what version of Excel is install on a system? | Is | there an environment variable or a Reg key that would give me this | information? | | Thank you. | | Eric | | | | | | | | |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel version
Jim,
I was going to suggest just trying to instantiate the version, but then noticed that I can only see the latest version, which seems strange. I get this in the Immediate window Excel version 10.0 is installed. Excel version 10.0 is installed. Private Sub CommandButton1_Click() Dim i As Long Dim RetVal As Variant RetVal = GetExcelVersions() If IsArray(RetVal) Then For i = LBound(RetVal) To UBound(RetVal) Debug.Print "Excel version " & RetVal(i) & " is installed." Next Else End If End Sub Private Function GetExcelVersions() As Variant Dim i As Long Dim ExcelApp As Object Dim Versions As String On Error Resume Next For i = 5 To 15 Set ExcelApp = CreateObject("Excel.Application." & i) If Not ExcelApp Is Nothing Then Versions = Versions & ExcelApp.Version & "," ExcelApp.Quit Set ExcelApp = Nothing End If Next If Len(Versions) 0 Then GetExcelVersions = Split(Left(Versions, Len(Versions) - 1), ",") Else GetExcelVersions = False End If End Function NickHK "Jim Rech" wrote in message ... My concern with registry entries in general is are they removed if the product is uninstalled? I think Office itself looks to the HKLM keys such as HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0. -- Jim "NickHK" wrote in message ... | Eric, | I have these 2 keys, as I have 2 versions of Office installed: | | HKEY_CLASSES_ROOT\Excel.Application.9 | HKEY_CLASSES_ROOT\Excel.Application.10 | | NickHK | | "Eric" wrote in message | ... | Hi Gary, | | Anything that would work outside Excel? | | Eric | | "Gary Keramidas" <GKeramidasATmsn.com wrote in message | ... | Application.Version | will return 11 for 2003, 12 for 2007 | | environ variables i know of for your reference: | | ALLUSERSPROFILE | APPDATA | CommonProgramFiles | COMPUTERNAME | ComSpec | FP_NO_HOST_CHECK | HOMEDRIVE | HOMEPATH | LOGONSERVER | NUMBER_OF_PROCESSORS | OS | Path | PATHEXT | PROCESSOR_ARCHITECTURE | PROCESSOR_IDENTIFIER | PROCESSOR_LEVEL | PROCESSOR_REVISION | ProgramFiles | SESSIONNAME | SystemDrive | SystemRoot | TEMP | TMP | USERDOMAIN | USERNAME | USERPROFILE | WecVersionForRosebud.828 | windir | | | -- | | | Gary | | | "Eric" wrote in message | ... | Hello, | | I am trying to identify what version of Excel is install on a system? | Is | there an environment variable or a Reg key that would give me this | information? | | Thank you. | | Eric | | | | | | | | |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel version
Nick-
but then noticed that I can only see the latest version When I look at Excel.Application.11 and Excel.Application.12 (I have only 2003 and 2007 installed on this machine) I see the same CLSID for both. That CLSID (00024500-0000-0000-C000-000000000046) points to Excel 2003 and when I run Excel.exe from Start-Run that's what I get. So it looks like whichever version re-registers itself last hogs all the keys. As a practical matter I think instantiating Excel, as you said, is the way to go. Although you apparently cannot enumerate through multiple versions that way, at least you can get the version you will actually get when you automate Excel, and I think that's all that matters. Jim "NickHK" wrote in message ... Jim, I was going to suggest just trying to instantiate the version, but then noticed that I can only see the latest version, which seems strange. I get this in the Immediate window Excel version 10.0 is installed. Excel version 10.0 is installed. Private Sub CommandButton1_Click() Dim i As Long Dim RetVal As Variant RetVal = GetExcelVersions() If IsArray(RetVal) Then For i = LBound(RetVal) To UBound(RetVal) Debug.Print "Excel version " & RetVal(i) & " is installed." Next Else End If End Sub Private Function GetExcelVersions() As Variant Dim i As Long Dim ExcelApp As Object Dim Versions As String On Error Resume Next For i = 5 To 15 Set ExcelApp = CreateObject("Excel.Application." & i) If Not ExcelApp Is Nothing Then Versions = Versions & ExcelApp.Version & "," ExcelApp.Quit Set ExcelApp = Nothing End If Next If Len(Versions) 0 Then GetExcelVersions = Split(Left(Versions, Len(Versions) - 1), ",") Else GetExcelVersions = False End If End Function NickHK "Jim Rech" wrote in message ... My concern with registry entries in general is are they removed if the product is uninstalled? I think Office itself looks to the HKLM keys such as HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0. -- Jim "NickHK" wrote in message ... | Eric, | I have these 2 keys, as I have 2 versions of Office installed: | | HKEY_CLASSES_ROOT\Excel.Application.9 | HKEY_CLASSES_ROOT\Excel.Application.10 | | NickHK | | "Eric" wrote in message | ... | Hi Gary, | | Anything that would work outside Excel? | | Eric | | "Gary Keramidas" <GKeramidasATmsn.com wrote in message | ... | Application.Version | will return 11 for 2003, 12 for 2007 | | environ variables i know of for your reference: | | ALLUSERSPROFILE | APPDATA | CommonProgramFiles | COMPUTERNAME | ComSpec | FP_NO_HOST_CHECK | HOMEDRIVE | HOMEPATH | LOGONSERVER | NUMBER_OF_PROCESSORS | OS | Path | PATHEXT | PROCESSOR_ARCHITECTURE | PROCESSOR_IDENTIFIER | PROCESSOR_LEVEL | PROCESSOR_REVISION | ProgramFiles | SESSIONNAME | SystemDrive | SystemRoot | TEMP | TMP | USERDOMAIN | USERNAME | USERPROFILE | WecVersionForRosebud.828 | windir | | | -- | | | Gary | | | "Eric" wrote in message | ... | Hello, | | I am trying to identify what version of Excel is install on a system? | Is | there an environment variable or a Reg key that would give me this | information? | | Thank you. | | Eric | | | | | | | | |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel version
Jim,
Seems that this may explain the behaviour: http://groups.google.co.uk/group/mic...86e198 266b8a However, I did see a post from Tom: http://groups.google.co.uk/group/mic...692a3c f63aaf that this is the normal, although that means that it not possible to Get/Create version specific objects, which I always thought was possible. Confused ? NickHK "Jim Rech" wrote in message ... Nick- but then noticed that I can only see the latest version When I look at Excel.Application.11 and Excel.Application.12 (I have only 2003 and 2007 installed on this machine) I see the same CLSID for both. That CLSID (00024500-0000-0000-C000-000000000046) points to Excel 2003 and when I run Excel.exe from Start-Run that's what I get. So it looks like whichever version re-registers itself last hogs all the keys. As a practical matter I think instantiating Excel, as you said, is the way to go. Although you apparently cannot enumerate through multiple versions that way, at least you can get the version you will actually get when you automate Excel, and I think that's all that matters. Jim "NickHK" wrote in message ... Jim, I was going to suggest just trying to instantiate the version, but then noticed that I can only see the latest version, which seems strange. I get this in the Immediate window Excel version 10.0 is installed. Excel version 10.0 is installed. Private Sub CommandButton1_Click() Dim i As Long Dim RetVal As Variant RetVal = GetExcelVersions() If IsArray(RetVal) Then For i = LBound(RetVal) To UBound(RetVal) Debug.Print "Excel version " & RetVal(i) & " is installed." Next Else End If End Sub Private Function GetExcelVersions() As Variant Dim i As Long Dim ExcelApp As Object Dim Versions As String On Error Resume Next For i = 5 To 15 Set ExcelApp = CreateObject("Excel.Application." & i) If Not ExcelApp Is Nothing Then Versions = Versions & ExcelApp.Version & "," ExcelApp.Quit Set ExcelApp = Nothing End If Next If Len(Versions) 0 Then GetExcelVersions = Split(Left(Versions, Len(Versions) - 1), ",") Else GetExcelVersions = False End If End Function NickHK "Jim Rech" wrote in message ... My concern with registry entries in general is are they removed if the product is uninstalled? I think Office itself looks to the HKLM keys such as HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0. -- Jim "NickHK" wrote in message ... | Eric, | I have these 2 keys, as I have 2 versions of Office installed: | | HKEY_CLASSES_ROOT\Excel.Application.9 | HKEY_CLASSES_ROOT\Excel.Application.10 | | NickHK | | "Eric" wrote in message | ... | Hi Gary, | | Anything that would work outside Excel? | | Eric | | "Gary Keramidas" <GKeramidasATmsn.com wrote in message | ... | Application.Version | will return 11 for 2003, 12 for 2007 | | environ variables i know of for your reference: | | ALLUSERSPROFILE | APPDATA | CommonProgramFiles | COMPUTERNAME | ComSpec | FP_NO_HOST_CHECK | HOMEDRIVE | HOMEPATH | LOGONSERVER | NUMBER_OF_PROCESSORS | OS | Path | PATHEXT | PROCESSOR_ARCHITECTURE | PROCESSOR_IDENTIFIER | PROCESSOR_LEVEL | PROCESSOR_REVISION | ProgramFiles | SESSIONNAME | SystemDrive | SystemRoot | TEMP | TMP | USERDOMAIN | USERNAME | USERPROFILE | WecVersionForRosebud.828 | windir | | | -- | | | Gary | | | "Eric" wrote in message | ... | Hello, | | I am trying to identify what version of Excel is install on a system? | Is | there an environment variable or a Reg key that would give me this | information? | | Thank you. | | Eric | | | | | | | | |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel version
Hi there,
Bumped into this : Microsoft Office Version Detector http://www.codeproject.com/useritems/OfficeVersion.asp Enjoy, Joop |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving a newer version of Excel using an older version (Excel 97) | Excel Discussion (Misc queries) | |||
| How do I save an Excel 97-2003 version or 2007 version for Mac 200 | Excel Discussion (Misc queries) | |||
| Macro - Save an Open Excel Version 4 as current version of Excel | Excel Programming | |||
| Recover earlier version of excel sheet after new version saved? | Excel Discussion (Misc queries) | |||
| How can I update the version of Excel 2000 9.0 to version 10.0 | Excel Discussion (Misc queries) | |||
![Eric[_35_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
