Saturday, December 22, 2007

MS Office 2007

Some of the new users in the office were given new laptops with MS Office 2007 preinstalled. I wrote a script so they'd save files in a format compatible with earlier versions of Office. The script worked but didn't persist after a restart so I'd to add it to the standard logon scripts for the domain. The following sets the saving defaults for Word, Excel and Powerpoint

The following is the content of the script. To use it, paste the following into notepad and save it with a .reg extension as it will edit your registry.

***************************************************************************
Windows Registry Editor Version 5.00

[HKEY_Current_USER\Software\Microsoft\Office\12.0\Excel\Options]
"DefaultFormat"=dword:00000038

[HKEY_Current_USER\Software\Microsoft\Office\12.0\Word\Options]
"DefaultFormat"="doc"

[HKEY_Current_USER\Software\Microsoft\Office\12.0\PowerPoint\Options]
"DefaultFormat"=dword:00000000

[HKEY_Local_Machine\Software\Microsoft\Office\12.0\Excel\Options]
"DefaultFormat"=dword:00000038

[HKEY_Local_Machine\Software\Microsoft\Office\12.0\Word\Options]
"DefaultFormat"="doc"

[HKEY_Local_Machine\Software\Microsoft\Office\12.0\PowerPoint\Options]
"DefaultFormat"=dword:00000000

***************************************************************************

To run it on startup save it in the netlogon directory of your domain controller or edit the group policy startup scripts for your PC. You'll find group policy settings by selecting Start / Run then enter gpedit.msc and press enter.

To run a .reg file silently on logon so there are no user prompts run the script as follows. Note the script is in the same directory as the logon script. Otherwise you can provide the path. The important bit here is that running script.reg /s will not do a silent install. The following will:

regedit.exe /s filename.reg


Hope this helps