guypb
Posts: 28
Joined: Thu Dec 18, 2008 5:16 pm

Determine MS Office Version

i am having to make some registry changes and need to associate them to the installed version of MS Office.
the key is normally of the format: "[ProgramFilesFolder]Microsoft Office\OFFICE11\EXCEL.EXE" /e "%1" - but of course OFFICE11 could be OFFICE12 or just OFFICE.
How do I determine what the current version is - or alternatively adjust the existing key.

cheers

BTW - regarding the new Office 2007 prequisite - can you do this for all versions of Office - or at least 2000+
Cosmin
Posts: 5797
Joined: Tue Jul 10, 2007 6:39 pm
Contact: Website

Re: Determine MS Office Version

Hi,

In order to detect the Office version installed you can use multiple searches, one for each Office version. If a search is successful, its property will be set to the result of the search. Therefore, you can use the properties of the searches to condition elements in the installation.
BTW - regarding the new Office 2007 prequisite - can you do this for all versions of Office - or at least 2000+
These improvements are on our TODO list and they will be available in a future version of Advanced Installer.

Regards,
Cosmin
Cosmin Pirvu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
pgarofalo
Posts: 9
Joined: Wed Apr 22, 2009 3:38 pm

Re: Determine MS Office Version

Cosmin, a bit of a twist on this question. I would like the setup program to determine if MS Excel is installed and if not display a dialog box. Is that doable? According to http://office.microsoft.com/en-us/orkXP ... 11033.aspx, I have to call MSIEnumProducts() from a program. My question: How can I invoke a custom logic from within Setup.exe? Is there any way I can link custom code to the setup program? Is there another way I can check for the installation of Excel?

Thanks,

Phil Garofalo
PMA Consultants
Chicago, IL
cyb
Posts: 43
Joined: Wed Apr 15, 2009 1:06 pm

Re: Determine MS Office Version

Hi Phil,

That can be done following the next steps:
- create a registry search for each version of Excel. The registries to look for are:

Code: Select all

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\10.0\Excel\InstallRoot
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\Excel\InstallRoot
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\12.0\Excel\InstallRoot
- go to the "Custom Actions" Page and create a "ScriptInline" custom action under "InstallUISequence->AppSearch" ;
- in the "Script Text" field type:

Code: Select all

MSGBOX "Your Message"
- set the custom action's condition to:

Code: Select all

(NOT SEARCH1) AND (NOT SEARCH2) AND (NOT SEARCH3)
where SEARCH1, SEARCH2 and SEARCH3 are the names of your searches.

You can also check this article.

Best regards,
cyb
Cosmin Budrica
Advanced Installer Team
http://www.advancedinstaller.com/
pgarofalo
Posts: 9
Joined: Wed Apr 22, 2009 3:38 pm

Re: Determine MS Office Version

Thanks Cosmin,

Phil
stevlina
Posts: 1
Joined: Mon Jun 01, 2009 11:45 am

Re: Determine MS Office Version

How do you make Microsoft Office 2007 look like 2003? I have Microsoft Office 2007, but I hate the new user interface, with the buttons on the top.... I need it to look like the old office, 2003, and run basically the same. Is there any way to do this without a huge amount of hassle? Thanks all
_______________
affiliateelite ~ affiliateelite.com ~ adgooroo ~ adgooroo.com
Last edited by stevlina on Sat Jun 06, 2009 11:05 am, edited 1 time in total.
Cosmin
Posts: 5797
Joined: Tue Jul 10, 2007 6:39 pm
Contact: Website

Re: Determine MS Office Version

Hi,

This doesn't seem related to Advanced Installer. Please note that this forum is for Advanced Installer support only.

Regards,
Cosmin
Cosmin Pirvu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

Return to “Common Problems”