So you painstakingly set up your Quick Access Toolbar preferences in every Office 2007 application to your liking. You have your favorite shortcuts for composing Outlook emails, setting up charts in Excel documents, and your obscure not-so-easy-to-get-to-in-the-Ribbon formatting control in Word. But now you have to set it all up again at home. There has to be an easier way!
Well, the officially supported way is to fire up Windows Easy Transfer or the User State Migration Tool, since Office 2007 defers settings transfers to those tools instead still offering the greatly missed "File and Settings Transfer Wizard" made famous in Office 2003. But both of those methods require (A) administrative access and (B) a lot of time. Maybe just setting it up again is easier...
Well it's not! The easiest way to transfer the Quick Access Toolbar from one computer to another is simply copying a few files in your Application Data folder. Here are the locations:
XP:
C:\Documents and Settings\\Local Settings\Application Data\Microsoft\Office\*.qat
Vista:
C:\Users\\AppData\Local\Microsoft\Office\*.qat
Simply copy the QAT file associated with the application (or form) you want the customized quick access toolbar for from your source computer to your destination. Done!
Additionally, if you are interested in exporting other settings (kids: don't try this at home), HKEY_CURRENT_USER\Software\Microsoft\Office\12.0 contains a wealth of settings that are ripe for exporting and importing. However, DON'T WRITE OVER THE "Registration" KEY! If you do, you will invalidate your Office Activation and you might have trouble reactivating it.