Solved

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

Posted on 2011-09-06
2
191 Views
Last Modified: 2012-05-12
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
Comment
Question by:LCMaurice
2 Comments
 
LVL 12

Accepted Solution

by:
Daz_1234 earned 250 total points
ID: 36488564
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
 

Author Closing Comment

by:LCMaurice
ID: 36931496
good one
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

896 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now