It’s time to wrap up this series on Office 2016 deployment. We’ve built several prerequisite application packages, some Global Conditions, and the Office application package itself. Because Microsoft recommends not installing multiple versions of Office together and because Office Setup cannot remove all components of previous versions, we built a Configuration Manager package with all of the OffScrub scripts from Microsoft Product Support Services to allow reliable removal of previous versions.
The application package we built last time brought everything together except the Offscrub package. That application package is useful for an operating system deployment task sequence or to device collections where you know that no member device has a version of Office already installed. To have reliable installations of Office 2016 with no previous versions, we need to add one more component: a task sequence.
Building the Configuration Manager Task Sequence
Create a custom task sequence. Do not specify a boot image. Assuming that you are installing multiple Office programs, here is a suggested name and description:
Name | Office Family 2016 (32-bit) [Remove existing] |
Description | Removes previous versions of Office programs and then installs Office, Project, and Visio 2016 and all of their prerequisites. |
You will have to give some careful thought to the content of these fields; both of them have rather short length limitations that prevent more accurate descriptions than what is shown above.
Right-click the newly-created task sequence, and click Edit. Now I will describe each step you should add to the task sequence.
Step 1: Start Software Center after restart
Type | Run Command Line |
Name | Start Software Center after restart |
Description | Software Center must be running in order for progress to be displayed. The intrinsic “start” command of cmd.exe must be used; otherwise, Software Center will start on sign-in, but the desktop will not be loaded until it is closed. |
Command line | "%SystemRoot%\System32\reg.exe" add "HKLM\Software\Microsoft\Windows\CurrentVersion\RunOnce" /v "!SoftwareCenterForOffice2016TS" /t REG_SZ /d "\"%SystemRoot%\System32\cmd.exe\" /C \"start \"Starting Software Center...\" \"%SystemRoot%\CCM\SCClient.exe\" softwarecenter:\"" /f /reg:64 |
Disable 64-bit file system redirection | Checked |
This step ensures that Software Center is restarted automatically the next time someone signs in. This is important to show status to the user in case the task sequence is being run. The exclamation point prefix on the RunOnce registry value defers deletion of the value until after the command has completed successfully. That means that the command will not be deleted if it fails, and it will therefore by tried again the next time the RunOnce key is evaluated.
Step 2: Restart the computer
Type | Restart Computer |
Name | Restart Computer |
Description | The “/Force” switch is being passed to all of the OffScrub scripts. This kills running Office programs and will thus cause data loss of any unsaved files. Restart to prevent this from happening. |
Specify what to run after restart | The currently installed default operating system |
Notify the user before restarting | Checked |
Notification message | Microsoft Office 2016 will be installed, and old versions of Office will be removed. The computer must restart to continue. Please save your work and close all programs. This upgrade process requires multiple restarts. You may sign into the computer after it restarts in order to view progress, but do not attempt use any programs until this process is complete. |
As the description says, the OffScrub scripts will all forcibly terminate any running Office application without prompting the user to save data. If a user runs this task sequence manually, this delayed restart step informs the user what is happening and gives him or her time to save data.
Step 3: Remove old versions of Office
Type | Group |
Name | OffScrub |
Description | Remove old versions of Microsoft Office. |
We’ll call all of the OffScrub scripts from inside this group.
Step 3a: Remove Office 2003
Type | Install Package |
Name | Remove Office 2003 |
Description | Runs OffScrub03 script from Microsoft Support. |
Install a single software package | Selected |
Package | Microsoft OffScrub |
Program | OffScrub03 |
Step 3b: Remove Office 2007
Add a step to remove Office 2007 just like the one for Office 2003, replacing property values as appropriate.
Steps 3c and 3d: Remove Office 2010
Add a step to remove Office 2010 just like the one for Office 2003, replacing property values as appropriate. Then, make a copy of it so that there are two identical steps that remove Office 2010. Make the following changes:
- Change the description of the first one to:
Runs OffScrub10 script from Microsoft Support and continues on errors. OffScrub10 uses non-zero exit codes for informational reporting, which are interpreted by ConfigMgr to be errors. - Set the first one to Continue on error (on the Options tab).
- Change the name of the second one to:
Remove Office 2010 (retry). - Change the description of the second one to:
Runs OffScrub10 script from Microsoft Support again and fails on errors. OffScrub10 uses non-zero exit codes for informational reporting, which are interpreted by ConfigMgr to be errors. - Add a condition to the second one (on the Options tab):
Task Sequence Variable _SMSTSLastActionSucceeded equals “false”
Microsoft was consistent in the return values for all of the OffScrub scripts except for the one for Office 2010. In this one, some non-error conditions are reported back via the script’s exit code, and unfortunately there is no way to specify success values for ConfigMgr package programs. The approach I chose was to run the script once ignoring errors, and then run it again, if needed, failing on errors (thus causing the task sequence to stop).
If the first run of the script is successful and returns 0 (zero), the task sequence will record “true” in the _SMSTSLastActionSucceeded variable, and the second run of the script will be skipped due to the condition.
If the first run of the script is successful and returns a non-zero informational value, the task sequence will record “false” in the _SMSTSLastActionSucceeded variable, and the second run of the script will be executed, but it will have nothing to do and so will finish quickly, returning 0 (zero) because it has no special information to report.
If the first run of the script fails and returns a non-zero failure value, the task sequence will record “false” in the _SMSTSLastActionSucceeded variable, and the second run of the script will be executed. Assuming the script runs into the same problem that it did during the previous try, it will fail again, but this time the task sequence engine will see the failure and stop the task sequence.
Step 3e: Remove Office 2013
Add a step to remove Office 2013 just like the one for Office 2003, replacing property values as appropriate.
Step 3f: Remove Office 2016
Add a step to remove Office 2016 just like the one for Office 2003, replacing property values as appropriate.
Step 3g: Remove Office Click-to-run
Add a step to remove Office Click-to-run just like the one for Office 2003, replacing property values as appropriate.
Back outside of the OffScrub group, we’re ready to start installing software. The instructions below install all of the Office prerequisites as separate task sequence steps. This provides better feedback to the user as to what is happening and should make it easier to follow along in the logs if something goes awry.
New Install Application steps have a Retry this step if computer unexpectedly restarts checkbox checked and the number of times to retry set to 2 on the options tab. Leave these default settings for all Install Application steps added below.
Step 4: Install .NET 3.5 SP1
Type | Install Application |
Name | Install .NET 3.5 SP1 |
Description | Leave blank. |
Install the following applications | Add the .NET Framework 3.5 SP1 application package that we created earlier as the only item in the list. |
Step 5: Start Software Center after restart
Copy the Start Software Center after restart step from the top of the task sequence and paste it here.
In my testing, installing the .NET Framework 4.x required a restart for completion, so we’ll set up Software Center to start again after that installation and restart is complete. At the very end of the task sequence, we’ll delete this registry value if it is still present. This would be the case if the computer already had .NET 4.5.2 or higher installed prior to running this task sequence.
Step 6: Install .NET 4.5.2 or higher
Type | Install Application |
Name | Install .NET 4.5.2 or higher |
Description | Leave blank. |
Install the following applications | Add the .NET Framework 4.5.2 or higher application package that we created earlier as the only item in the list. |
Step 7: Install Report Viewer 2008
Type | Install Application |
Name | Install Report Viewer 2008 |
Description | Microsoft Report Viewer 2008 is required for Database Compare 2016, which is a companion program to Access 2016. |
Install the following applications | Add the Microsoft Report Viewer Redistributable 2008 (KB971119) application package that we created earlier as the only item in the list. |
Step 8: Install Office Professional Plus 2016 (32-bit)
Type | Install Application |
Name | Install .NET 3.5 SP1 |
Description | Leave blank. |
Install the following applications | Add the Microsoft Office Professional Plus 2016 (32-bit) application package that we created earlier as the only item in the list. |
Steps 9 and 10: Install Visio and Project
Add Install Application steps for the Visio and Project application packages that we created earlier. These will be much like the Office installation step above.
Step 11: Install Software Updates
Type | Install Software Updates |
Name | Install Software Updates |
Description | Leave blank. |
Install software updates assigned to the destination computer | All Software Updates |
Step 12: Remove RunOnce value to start Software Center
Properties tab | |
Type | Run Command Line |
Name | Remove RunOnce value to start Software Center |
Description | If the OS was fully patched (including having .NET 4.5.2 or higher installed) prior to running this task sequence, no restarts may have been triggered since the last “Start Software Center after restart” step, so remove the registry value if it is present. |
Command line | "%SystemRoot%\System32\reg.exe" delete "HKLM\Software\Microsoft\Windows\CurrentVersion\RunOnce" /v "!SoftwareCenterForOffice2016TS" /f /reg:64 |
Disable 64-bit file system redirection | Checked |
Options tab | |
Success codes | 0 1
That’s the number zero, followed by a space, followed by the number one. |
Continue on error | Checked |
The description field contents pretty much explains what this is doing. Note the changes to the Options tab, though. If reg.exe
deletes the value successfully, it returns 0 (zero). If the value is not there, though, it returns 1. Since we just want to run the command and consider it successful no matter what, we need to set 0 and 1 as valid success codes as shown above. As insurance that some other unknown error condition won’t cause the task sequence to register as a failure, we also check the Continue on error box.
Advice
That’s it! Running this task sequence will ensure that target machines have exactly one version of Microsoft Office—Office 2016—and that all of its prerequisites are present. You will want to think carefully about how you deploy it. If your users are conditioned to sign out at the end of each work day, you may be able to deploy the task sequence as required for a specific time overnight without many problems. If users typically leave their computers turned on and signed in, with unsaved data open in various applications, you may want to just deploy the task sequence as “Available”, and then notify users via e-mail that they can run the task sequence themselves from Software Center. Running it manually will give users the warning that the computer will be restarted and give them time to save their data.
Be advised that in my testing, this task sequence took a minimum of 30 minutes to run and typically took quite a bit longer; just installing the updates takes a while. If users will run the task sequence themselves, I suggest advising them to begin the task sequence before going to lunch or before leaving for the day. If you know that your environment doesn’t have certain versions of Office, you could disable the corresponding OffScrub step(s) in order to save time. For example, I don’t think there are any Office 2003 installations remaining in my organization, so I disabled that step. Further, we no longer have a site license for Project, so I removed it. With those changes, here is what my task sequence looks like this: