Solved

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

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Join & Write a Comment

Suggested Solutions

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

744 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

13 Experts available now in Live!

Get 1:1 Help Now