View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Howard Kaikow Howard Kaikow is offline
external usenet poster
 
Posts: 269
Default Excel registry key

"Jon Peltier" wrote in message
...
FWIW, Office 10 and 9 have similar keys

Office 10:
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared
Tools\MSInfo\Categories\Applications10\Excel10]

Office 9:
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared
Tools\MSInfo\Categories\Applications\Excel]

You could also look for

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\X.0\C ommon\InstallRoot]

which contains a key named 'Path' with the installation directory of that
version of Office. This is consistent for Excel 8.0 through 12.0. If you
want to look for a specific product, use Excel, Word, Access, etc., in

place
of Common.


Thanx.

I'll check version 8 later this week.

1. I prefer to use the Windows API to get the path, etc. For example, see
' KB 183544: How To Call CLSID And ProgID Related COM APIs in Visual
Basic

2. I have not yet found a way, using the Windows API, to get the product
"title" in an easily determined way.
The key I listed seems to be the most direct way and is easily programmable
as the version can be determind using Windows API, e.g., as in KB 183544,
without starting Excel.