How to deploy QAT toolbars in Office 2007.
By default Office 2007 QAT files are stored Office folder that is in the “local” profile.
In Windows Xp this location = "%userprofile%\local settings\application data\Microsoft\office
In Vista\Windows 7 this location = %appdata%\local\Microsoft\Office
When adding QAT files to the “add files” section of the OCT the default dropdown location that you should choose is “[AppDataFolder]\Microsoft\Office”. The problem with this however is that “[AppDataFolder]\Microsoft\Office” from the OCT actually ends up pointing to these “roaming” locations:
In Windows Xp this location = "%userprofile%\application data\Microsoft\office
In Vista\Windows 7 this location = %appdata%\roaming\Microsoft\Office
This is a problem, because the OCT is placing the QAT files in the roaming section of the users profile, but Office looks in the “local” section of the users profile by default.
To fix this, Microsoft has provided a hotfix that forces Office to use the “roaming” folder in the users profile instead. This hotfix is from KB955142 This hotfix has since also been superseded by Sp2. These instructions for deploying the QAT files assumes that you will be applying the hotfix, or pushing Sp2 with your Office 2007 deployment. If you are pushing Sp2 with your deployment you do NOT need the hotfix from KB955142. Installing the Hotfix or Sp2 to resolve this problem is the first part of the solution. The next part of the solution is to also add a reg key that tells Office to use the Roaming folder.
1. Create the QAT files
a. Go to a machine with office 2007 installed and modify the Quick Access Toolbar.
b. The folder that contains the .QAT file is hidden so we must show hidden files and folders. To do this, open my computer, click tools, folder options, then click on the view tab. Put a dot in "show hidden files and folders"
c. Browse out to the "%userprofile%\local settings\application data\Microsoft\office" folder. In here you will see a .qat file for each app.
2. Add them to the OCT in the “add files” section. For the destination path choose “[AppDataFolder]\Microsoft\Office”
Should look like so..
3. Add the following “dword” registry key to the “Add reg keys” section. (This step tells Office to use the roaming folder rather than the local folder for QAT files.)
HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Common\Toolbars\ QuickAccessToolbarRoaming =1
4. Save and close the custom.msp
5. Extract the MSP files from the following private hotfix KB955142 or Sp2 and place them in the updates folder of your office 2007 installation source.
To extract Office 2007 patches use the following syntax: office-kb955142-fullfile-x86-glb.exe /extract
6. Install Office.