Solved

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

Posted on 2011-09-06
2
193 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 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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

Suggested Solutions

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
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 the scrolling table in Microsoft Excel using the INDEX function.

730 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