Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How do I customize the Office 2007 QuickAccessToolbar for deploying it consistently across the enterprise?

Posted on 2008-10-20
3
Medium Priority
?
554 Views
Last Modified: 2013-12-12
How can I create multiple customized QuickAccessToolbars for Office 2007.  I'm familiar with the OCT and customizing Office installations.  I've created /deployed custom Office installs for my company for Office XP, 2003, and 2007.  I've created multiple .MSPs for deploying Office 2007 but have not been able to create customized QuickAccessToolbar(s) or been able to figure out how to deploy anything other than the default QAT buttons.  I know how to customize the QAT on individual PCs but need to do so company-wide.  
0
Comment
Question by:colins121
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 

Author Comment

by:colins121
ID: 22767895
Simply copying the .qat files to each PC isn't going to work unless there is a way to replicate to all users profile on the all PCs.  I've customized them on my PC but need to deploy them with Office when it gets deployed.  One option is to copy it to the "default user" profile but that will only affect users that haven't logged onto the PC before.
0
 
LVL 7

Accepted Solution

by:
enzogoy earned 750 total points
ID: 22782751
I think there is only one posible solution is using script to copy it to the local profile which you already knew.  More information about it if you would like:
http://www.itexperience.net/2008/03/13/quick-access-toolbar-in-office-2007-and-roaming-profiles/
http://msthings.spaces.live.com/Blog/cns!BFE88543FF6C8C5F!140.entry

In the link below, galaxiom has 2 script for copy the .qat to profile and server.  It may help you not to spend time to write another script. :)
http://www.technologyquestions.com/technology/microsoft-office/232919-office-2007-roaming-qat-quick-access-toolbar.html

0
 

Author Closing Comment

by:colins121
ID: 31535342
The links that you provided are helpful.  I ended up going doing this via Group Policy using a crude script (batch file) that verifies if Office 2007 (or any of its components) is installed, the OS version, and checks to see if each of the .qat that we need on our users' systems exist. If not, the individual .qat are copied to the users profiles.

Doing this via Group Policy worked out well since the combined size of all the .qat files is a whopping 8K!  The batch file itself is 2K.  It runs pretty quickly too.  We dont use roaming profiles so I didnt have to do any logoff script.  Remote users have to deal with any lag the script and file copy cause but based on their geography (Bay Area) my user base has a good percentage high-speed access.

Below is the script that I used.

@echo OFF
if not exist "%PROGRAMFILES%\Microsoft Office\Office12\" goto END


ver | find "Version 5.1"
if errorlevel 1 goto NotXP
if exist "%userprofile%\Local Settings\Application Data\Microsoft\OFFICE\excel.qat" goto OLKItem
xcopy "Excel.qat" "%userprofile%\Local Settings\Application Data\Microsoft\OFFICE\" /Y

:OLKItem
if exist "%userprofile%\Local Settings\Application Data\Microsoft\OFFICE\olkmailitem.qat" goto OLKRead
xcopy "olkmailitem.qat" "%userprofile%\Local Settings\Application Data\Microsoft\OFFICE\" /Y

:OLKRead
if exist "%userprofile%\Local Settings\Application Data\Microsoft\OFFICE\olkmailread.qat" goto PPT
xcopy "olkmailread.qat" "%userprofile%\Local Settings\Application Data\Microsoft\OFFICE\" /Y

:PPT
if exist "%userprofile%\Local Settings\Application Data\Microsoft\OFFICE\PowerPoint.qat" goto WORD
xcopy "PowerPoint.qat" "%userprofile%\Local Settings\Application Data\Microsoft\OFFICE\" /Y

:WORD
if exist "%userprofile%\Local Settings\Application Data\Microsoft\OFFICE\Word.qat" goto END
xcopy "Word.qat" "%userprofile%\Local Settings\Application Data\Microsoft\OFFICE\" /Y
goto END



:NotXP
ver | find "Version 6.0"
if errorlevel 1 goto END
if exist "%USERPROFILE%\AppData\Local\Microsoft\office\Excel.qat" goto OLKItemV
xcopy "Excel.qat" "%USERPROFILE%\AppData\Local\Microsoft\office\" /Y

:OLKItemV
if exist "%USERPROFILE%\AppData\Local\Microsoft\office\olkmailitem.qat" goto OLKReadV
xcopy "olkmailitem.qat" "%USERPROFILE%\AppData\Local\Microsoft\office\" /Y

:OLKReadV
if exist "%USERPROFILE%\AppData\Local\Microsoft\office\olkmailread.qat" goto PPTV
xcopy "olkmailread.qat" "%USERPROFILE%\AppData\Local\Microsoft\office\" /Y

:PPTV
if exist "%USERPROFILE%\AppData\Local\Microsoft\office\PowerPoint.qat" goto WORDV
xcopy "PowerPoint.qat" "%USERPROFILE%\AppData\Local\Microsoft\office\" /Y

:WORDV
if exist "%USERPROFILE%\AppData\Local\Microsoft\office\Word.qat" goto END
xcopy "Word.qat" "%USERPROFILE%\AppData\Local\Microsoft\office\" /Y
goto END

:END


0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free when…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

722 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