ToolBox -

November 2nd, 2012

Print this article

Add a comment!

After customizing a Quick Access Toolbar, you can quickly copy it to other computers. You can add your favourite commands or even missing commands to the QAT for quick access. All of the Office applications support a QAT.

If you have or support more than one system, you don’t have to duplicate your efforts where QATs are concerned. Instead, customize one and copy it to other computers.  Just be careful because Office 2007 QAT files aren’t compatible with Office 2010 QAT files.

Office 2007

Each application has its own QAT file, as listed in the following table. When copying Outlook files, be sure to select the right one (or all of them) as your copy of Outlook might have several .qat files.

 

Program

Feature area

File name

Access 2007

Access.qat

Excel 2007

Excel.qat

Outlook 2007

Contacts

Olkaddritem.qat

Calendar

Olkapptitem.qat

Distribution list

Olkdistitem.qat

Journal entry

Olklogitem.qat

Mail

Olkmailitem.qat

Post in folder

Olkpostitem.qat

Tasks

Olktaskitem.qat

PowerPoint 2007

PowerPoint.qat

Word 2007

Word.qat

 

Office saves the .qat files in different locations, depending on your operating system.

 

NOTE: to find these file locations make sure in the Folder Option, under View, you have selected to show hidden files, folders, and drives and unselected Hide extensions for Known file types.

 

clip_image001[6]

·         Windows XP usually saves .qat files in the following folder:

o   C:\Documents and Settings\username\Local Settings\Application Data\Microsoft\Office

·         If you’re running Windows Vista and Windows 7, they’re most likely in this folder:

o   C:\Users\username\AppData\Local\Microsoft\Office

 

Run a Windows Search to find the files if your system is configured differently. After locating the .qat file, copy it to another computer. Be sure to note the actual location in your source computer and copy the file to the same location on the target computer.

Office 2010

Of course, it’s different for Office 2010. In this version, the .qat files are now .officeUI files.

 

·         In Windows XP, look for these files in the following folder:

o   C:\Documents and Settings\username\Local Settings\Application Data\Microsoft\Office

·         In Vista and Windows 7 systems, look for these files in this folder:

o   C:\Users\username\AppData\Local\Microsoft\Office

Upgrading from 2007 to 2010

If you’re upgrading to 2010 from 2007 and you’re supporting several systems:

1.       Save the .qat files to disc or someplace safe so they’re not destroyed during the installation of Office 2010.

2.       After installing Office 2010, give the new .officeUI files a new extension name, such as .officeUIorg, so you can recognize them later. You want to keep them around, just in case.

3.       Then, copy the 2007 .qat files in to the above folder location and rename it to use the .officeUI extension to the appropriate folder in Office 2010.

 

I repeat, do not write over the .officeUI files. Rename them, so you can retain those files in installation order.

 

Thanks to: Susan Harkins

http://www.techrepublic.com/blog/msoffice/copy-office-2007-and-2010-quick-access-toolbars/4253