Hi Bathan,

Bathan wrote:
Im having some trouble trying to get Excel full version. Im working
with Excel 2003 and I need to know if its professional or "Basic" and
if it has any Service Packs.

My code is written in C#, I can get the "global" version (11.0) but
not the real/full one (11.8033.8028 for example).

Is there any way to find out the Excel/Office version using Automation
? Any code in any language will be appreciated.

You can get the major version # and the build # by using the Version and
Build properties of the Application object:

Debug.Print Application.Version
Debug.Print Application.Build

This will help you determine what version and SP level the user is on:

http://support.microsoft.com/kb/821549

I'm not sure how you would go about determining the "type" of Excel install
(ie, basic, pro, dev). Maybe the registry would have what you need?

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\ Common\ProductVersion\ProInfo

Or you could enumerate the subkeys of:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\ Registration

And look for one with "ProductNameNonQualified" = "Microsoft Office 2003".
Then look for a value in that key named "ProductName", which for me is
"Microsoft Office Professional Edition 2003".

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]