Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 60
Default How to determine Office version

Hello,
Does anyone know how to programmatically determine the version of Office
that is installed during an installation? That is, I will probably need to
check via a registry entry if possible. If not, if I had to check one of the
Office exe for version but registry is preferred. I couldn't find any MSDN
and KB articles on such. I am trying to determine where the Office templates
folder going by the version of Office.
Thanks, God bless
Van
  #2   Report Post  
Posted to microsoft.public.excel.programming
RWN RWN is offline
external usenet poster
 
Posts: 104
Default How to determine Office version

"Application.Version"

--
Regards;
Rob
------------------------------------------------------------------------
"VanS" wrote in message
...
Hello,
Does anyone know how to programmatically determine the version of Office
that is installed during an installation? That is, I will probably need to
check via a registry entry if possible. If not, if I had to check one of the
Office exe for version but registry is preferred. I couldn't find any MSDN
and KB articles on such. I am trying to determine where the Office templates
folder going by the version of Office.
Thanks, God bless
Van



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 60
Default How to determine Office version

Rob,
Thanks for your reply.
However, as mentioned, I need to determine the version during the
installation via my Wise installer. That is why I was wondering if there were
a registry entry that reveals that. Else there is a method in the Installer I
can use to determine the file version of an Office exe.
Thanks, God bless
Van

"RWN" wrote:

"Application.Version"

--
Regards;
Rob
------------------------------------------------------------------------
"VanS" wrote in message
...
Hello,
Does anyone know how to programmatically determine the version of Office
that is installed during an installation? That is, I will probably need to
check via a registry entry if possible. If not, if I had to check one of the
Office exe for version but registry is preferred. I couldn't find any MSDN
and KB articles on such. I am trying to determine where the Office templates
folder going by the version of Office.
Thanks, God bless
Van




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How to determine Office version

There are registry entries to determine the Office version. I use it in my
Installshield script. The entries are dependent on Office version 9, 10,
11, etc.

The key a
Key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\10.0\ Common\ProductVersion
Sub-Key: LastProduct

Key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\ Common\ProductVersion
Sub-Key: LastProduct

For versions earlier than 10, MS does not put the ProductVersion key, in
such case, I check for the Excel key\InstallRoot and if I find it, I know
that Excel is installed. (In my case, I know that the user have to install
Excel, so my checking for Excel is valid)

--
Message posted via http://www.officekb.com
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 339
Default How to determine Office version


"VanS" wrote in message
...
Rob,
Thanks for your reply.
However, as mentioned, I need to determine the version during the
installation via my Wise installer. That is why I was wondering if there

were
a registry entry that reveals that. Else there is a method in the

Installer I
can use to determine the file version of an Office exe.
Thanks, God bless
Van

"RWN" wrote:

"Application.Version"


I'm pretty sure you can create a reference to Excel and call
Application.Version from within your installer. That's what we did in my
last job althofúgh we used InstallShield.

/Fredrik





  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 60
Default How to determine Office version

Hi Cherian,
Thanks for your input.
I tried those entries but I found a problem. I previously had Office XP
installed, then uninstalled, and now have Office 2003. But the registry
entries you gave show both of them installed, even though only the later
version is. Don't know if you came across this issue, or found a workaround.
However, I found that I could access a given Application entry under the
HKCR section of the registry. EG:
HKCR\Excel.Application\CurVer
I found this worked even for an older Office 97 version. Same for Word, etc.
Thanks again, God bless
Van

"Cherian D via OfficeKB.com" wrote:

There are registry entries to determine the Office version. I use it in my
Installshield script. The entries are dependent on Office version 9, 10,
11, etc.

The key a
Key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\10.0\ Common\ProductVersion
Sub-Key: LastProduct

Key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\ Common\ProductVersion
Sub-Key: LastProduct

For versions earlier than 10, MS does not put the ProductVersion key, in
such case, I check for the Excel key\InstallRoot and if I find it, I know
that Excel is installed. (In my case, I know that the user have to install
Excel, so my checking for Excel is valid)

--
Message posted via http://www.officekb.com

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I determine if a version of Excel 2007 is professional? Kevin Excel Discussion (Misc queries) 2 June 11th 08 01:44 PM
Which version of Office should I buy..? jack8844 Excel Discussion (Misc queries) 10 April 3rd 08 04:34 AM
which office version am i running amar Excel Discussion (Misc queries) 2 February 1st 07 11:41 PM
Determine version of .xls file from VB6 Wozza Excel Programming 0 October 14th 04 01:41 PM
Office automation application which will work with any version of office C#.NET Silly Programmer Excel Programming 1 February 21st 04 10:54 AM


All times are GMT +1. The time now is 10:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"