Prerequisites install condition Office/Excel 2007+

[doctorp]

HI there

My software solution needs to either have:

Office 2007 Primary Interop Assemblies (but only when Office 2007 is installed)
Office 2010 Primary Interop Assemblies (but only when Office 2010, 2013 is installed)

Installed as Prerequisites.

How do I specifiy this in the install conditions?
Ideally checking a version number. So the logic would be something like this.

Install Office 2007 Primary Interop Assemblies, only when
Office 2007 installed = TRUE, and
Office 2007 Primary Interop Assemblies installed = FALSE

Install Office 2010 Primary Interop Assemblies, only when
Office 2010 or Office 2013 installed = TRUE, and
Office 2010 Primary Interop Assemblies installed = FALSE

Any ideas?

[Dan]

Unfortunately it is a little harder to define the install condition for the Install Office 2007 Primary Interop Assemblies and Install Office 2010 Primary Interop Assemblies. The easiest way for you is to condition its installation behavior in the Feature Properties and leave the Always install prerequisite option enabled in the install conditions tab for this prerequisite.

Please note that when a Feature - based prerequisite automatically it is added a new Feature in the Organization page.

For the Office 2007 Primary Interop Assemblies you can go in the Search page and add the following Extended Search Properties
1) INTEROP2007 - check if Office 2007 Primary Interop Assemblies is installed
Criteria: Product Version (identify by Product Code)
Product Code: {50120000-1105-0000-0000-0000000FF1CE}

2)OFFICE2007 - check if Office 2007 is installed
Criteria: Registry key exist
Registry key:HKLM\SOFTWARE\Microsoft\Office\12.0\Access\InstallRoot

You can enable the Not installed option from its feature properties and add a statement like that ( NOT INTEROP2007 ) AND ( NOT OFFICE2007 ) in the Installed if: line.
Where:

• -INTREROP2007 is the property name assigned to the Office 2007 Primary Interop Assemblies search
  - OFFICE2007 is the property name assigned to the Office 2007 search

For the Office 2010 Primary Interop Assemblies you can go in the Search page and add the following Extended Search Properties
1) INTEROP2010 - check if Office 2010 Primary Interop Assemblies is installed
Criteria: Product Version (identify by Product Code)
Product Code: {90140000-1146-0000-0000-0000000FF1CE}

2)OFFICE2010 - check if Office 2010 is installed
Criteria: Registry key exists
Registry key: HKLM\SOFTWARE\Microsoft\Office\14.0\Access\InstallRoot

3)OFFICE2013 - check if Office 2013 is installed
Criteria: Registry key exists
Registry key: HKLM\SOFTWARE\Microsoft\Office\15.0\Access\InstallRoot

You can enable the Not installed option from its feature properties and add a statement like that ( OFFICE2010 OR OFFICE2012) AND ( NOT INTROP2010) in the Installed if: line.
Where:

• -OFFICE2010 is the property name assigned to the Office 2010 search
  -OFFICE2013 is the property name assigned to the Office 2013 search
  -INTREROP2010 is the property name assigned to the Office 2010 Primary Interop Assemblies search

If you need any help, please let us know.

Best regards,
Dan

[doctorp]

Hi Dan

I'm clear on the first step - doing 2007. But the second step is a little unclear to me.

When I go to create an extended search it only allows me to create a search for a single property.

How do I add multiple statements?

Where do I write "You can enable the Not installed option and add a statement like that ( OFFICE2010 OR OFFICE2012) AND ( NOT INTROP2010) in the Installed if: line?

[doctorp]

Hi Dan

Other issue I can't resolve. When I inspect regedit I have the following key:

HKLM\SOFTWARE\Microsoft\Office\15.0\Excel

Why can't I see this via Advanced Installer?

When I override it with a manual typed path to be HKLM\SOFTWARE\Microsoft\Office\15.0\Excel

It returns SUCCESS when performing "REGISTRY KEY DOES NOT EXIST". However it does actually exist.

Any ideas?

[Dan]

How do I add multiple statements?

You can add in the Search page a new Extended Search Properties for every search you need to do.
e.g.
1) in order to see if Office 2007 Primary Interop Assemblies is installed you can use the Product Version (identify by Product Code) extended search
2) in order to see if if Office 2010 is installed you can use the Registry key exists extended search
3) in order to see if if Office 2013 is installed you can use the Registry key exists extended search

Where do I write "You can enable the Not installed option and add a statement like that ( OFFICE2010 OR OFFICE2012) AND ( NOT INTROP2010) in the Installed if: line?

Fist of all you need to add the Office 2007 Primary Interop Assemblies as a Feature based prerequisite. Please note that when a Feature - based prerequisite automatically it is added a new Feature in the Organization page.
You can enable the Not installed option from the installation behavior of the Feature Properties. Also, you can enable the Add Install-time Conditions in order to add the ( OFFICE2010 OR OFFICE2012) AND ( NOT INTROP2010) statement for the Installed if line.

It returns SUCCESS when performing "REGISTRY KEY DOES NOT EXIST". However it does actually exist

I’m not sure why you encountered this behavior. Can you please give us more details about the Operating System (x64 or x86 bit) and what version of Microsoft Office(x64-bit or x86-bit) you are using on your machine so we can investigate this?
You can also use the regedit.exe utility tool so you can see the registry entrance you should search for.

Best regards,
Dan

[doctorp]

HI Dan

I have been using the regedit tool to check - that is why I am confused. I can see the entries in regedit however they are not appearing in the installer dialog.

I am running a 64 bit machine with windows 7.

Thanks

[Dan]

Hi,

You can check our guide on The Search Page for a detailed description on how to use the Search feature in Advanced Installer. If you still can not troubleshoot the issue, then please send your .AIP (project file) or a sample that accurately reproduces this behavior and a detailed test case to support at advancedinstaller dot com so we can further investigate the issue.

Also, you can take a look on our "Search the 64-bit portion of the registry" ?? forum thread which debates a similar issue.

Please let us know if that helped.

Best regards,
Dan