[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 201
  • Last Modified:

Upgrade just Excel 2003 to Excel 2007 and keep the other programs 2003 with an msi

Hi,
I have seen alot of documents regarding doing the above with an msi. Has anyone achieved this with minimum fuss using a group policy msi?
Many thanks
0
LCMaurice
Asked:
LCMaurice
1 Solution
 
Daz_1234Commented:
This should do it - the instructions are for Office 2007 Enterprise edition.  I have done the xml and command line bit myself in our live environment and it worked, but I have not used GPOs to deploy before.

1. Copy the entire Office 2007 install files somewhere on the network and allow access to the users / groups that will have the GPO assigned (you might also need to add the computer accounts or "Domain Computers").  The folder will have setup.exe (and other files) in it and around 17 subfolders.

2. Create an XML file called something like "Config_Excel_Only.xml" with the following contents, and file it the same folder as the setup.exe (replace Enterprise with ProPlus,  Standard,  Pro as required for your version):
<!-- Installs Microsoft Excel 2007 only -->

<Configuration Product="Enterprise">
  <Display Level="Basic" NoCancel="No" SuppressModal="Yes" />
  <Setting Id="SETUP_REBOOT" Value="NEVER"/>

  <!-- Install Excel -->
  <OptionState Id="EXCELFiles" State="local" Children="force" />


  <!-- Do not install Access -->
  <OptionState Id="ACCESSFiles" State="absent" Children="force" />

  <!-- Do not install PowerPoint -->
  <OptionState Id="PPTFiles" State="absent" Children="force" />

  <!-- Do not install Word -->
  <OptionState Id="WORDFiles" State="absent" Children="force" />

  <!-- Do not install Groove -->
  <OptionState Id="GrooveFiles" State="absent" Children="force" />

  <!-- Do not install InfoPath (XDOCSFiles = InfoPath) -->
  <OptionState Id="XDOCSFiles" State="absent" Children="force" />

  <!-- Do not install Outlook -->
  <OptionState Id="OUTLOOKFiles" State="absent" Children="force" />

  <!-- Do not install OneNote -->
  <OptionState Id="OneNoteFiles" State="absent" Children="force" />

  <!-- Do not install Publisher -->
  <OptionState Id="PubPrimary" State="absent" Children="force" />
</Configuration>

Open in new window

3. Create a GPO Logon script "install_Excel2007.vbs" with the following contents:
'# Install Excel 2007 only
Set wshShell = CreateObject("WScript.Shell")
strInstallLocation = "\\server\share\MSO2007"
wshShell.Run """" & strInstallLocation & "\setup.exe"" /config """ & strInstallLocation & "\Config_Excel_Only.xml""", 1, True

Open in new window

4. Assign the logon script GPO to the users / groups that require it, and log one on!

Note: you must use the GPO logon script not the normal logon script because this must run as the System account not the user (unless they are an administrator).

Good luck,
Daz.
0
 
LCMauriceAuthor Commented:
good one
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now