?
Solved

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

Posted on 2011-09-06
2
Medium Priority
?
195 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 13

Accepted Solution

by:
Daz_1234 earned 750 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

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

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

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

762 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