The QAT File


The only user interface element in Excel 2007 that's customizable by the end user is the Quick Access Toolbar. The information for the QAT is stored in a file named Excel.qat, and this file is located here:

 C:\Documents and Settings\  <username>  \Local Settings\Application Data\ Microsoft\OFFICE 

This file is updated whenever a change is made to the QAT. It's updated immediately, not when Excel is closed.

Excel.qat is an XML file, and you can view it using an XML editor, a Web browser, or Excel. To view this file in Excel, follow these steps:

  1. Make a copy of the Excel.qat file.

  2. Add an XML extension to the copy of the file so that the name is Excel.qat.xml .

  3. Choose Office image from book Open to open the file or just drag it into Excel's window.

  4. You'll see a dialog box with some options; choose As an XML Table.

Figure 4-8 shows an imported Excel.qat file (the file is displayed as a table). This QAT has three commands in addition to the eleven default commands. Of the default commands, only three are visible.

image from book
Figure 4-8: Viewing a QAT data file in Excel.

It's possible to share a QAT with other users. For example, you may have customized your QAT with two dozen useful tools. If a colleague is impressed, just give him a copy of your Excel.qat file and tell him where to put it.

Don't attempt to modify the Excel.qat file unless you know what you're doing.




Excel 2007 Power Programming with VBA
Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)
ISBN: 0470044012
EAN: 2147483647
Year: 2007
Pages: 319

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net