This article describes the location of the toolbar file for the Quick Access
Toolbar for the 2007 Microsoft Office programs.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;926805
The default location (local settings\appdata) is not a location that the OCT
can add files to by default. This makes deploying the .QAT file through the
OCT a bit tricky since the OCT is not coded in a way that it can do it by
itself. Below are instructions for using a .bat file inside the OCT to deploy
the Quick Access Toolbar.
Here is how you could create and then deploy specific quick access toolbars
to all users.
1. Goto a machine with office 2007 installed and modify the Quick Access
Toolbar. (In this example I’ll use Word, but these steps apply for each app)
2. 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â€
3. Browse out to the “%userprofile%\local settings\application
data\microsoft\office†folder. In here you will see a .qat file for each app.
In this example you can see the word .qat file that has been created after I
modified my quick access toolbar for word.
4. Copy the .qat files onto a share that everyone will have access to. In my
example I am using \\erictermserv\off2007\Qat
5. Create a .bat file with the following script. (Change the
“\\erictermserv\Off2007\Qat\*.qat†to a server and location that is
applicable in your environment)
Batch excerpt:
-----------------------------------
@echo off
IF "%LOCALAPPDATA%"=="" Set LOCALAPPDATA=%USERPROFILE%\Local
Settings\Application Data
COPY \\erictermserv\Off2007\Qat\*.qat “%LOCALAPPDATA%â€\Microsoft\Office
-----------------------------------
6. Use the OCT to create a custom .MSP. In the OCT add the .BAT file to the
“add files†section.
7. In the OCT also modify the “Add installations and run programs†to run
the .bat file after office has installed.
8. Then when you install make sure to use the .msp file that was created
with the .OCT.
