Return Office 2010 SKU

[NDog]

I am trying to write a script to return the version of Office 2010 installed

According to this Microsoft Article http://support.microsoft.com/kb/2186281 there are certain SKUs that can be used to identify the installed version

Each GUID uses the following format:

{BRMMmmmm-PPPP-LLLL-p000-D000000FF1CE}

Product ID SKU

0011 Microsoft Office Professional Plus

0012 Microsoft Office Standard 2010

0013 Microsoft Office Home and Business

0014 Microsoft Office Professional 2010

Here is an example from my registry - Microsoft Office Professional Plus 2010 because of the 0011

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{90140000-0011-0000-0000-0000000FF1CE}

This would not be a good example (notice the additional string)

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{90140000-0011-0000-0000-0000000FF1CE}_Office14.PROPLUS_{047B0968-E622-4FAA-9B4B-121FA109EDDE}

My problem is I do not know how to split the string to search for these 2 consitant values, being the PPPP being the SKU and the end part 000000FF1CE

{xxxxxxxx-PPPP-xxxx-xxxx-x000000FF1CE}

If anyone can help me use this information to return the Office 2010 Version installed I would be thankful

[Bert]

is the number of characters in the string constant? If so just use stringsplit then stringleft or stringright to get the string you need.

edit: stringmid would also do it.

Edited September 13, 2011 by MPH