Copy quick access bar to another PC?

[Jason]

Does anyone know if there is any way to copy a customised quick access
bar between PCs and installations of Excel?

I'd like to use my bar from work at home without needing to re-create it.

Many thanks....Jason

---

 

[Ron de Bruin]

Hi Jason

See the path where you can find it in this article
http://www.rondebruin.nl/imageqat.htm

 

[Jason]

Thanks Ron. Which part of the article ? Is it the Copy a customized QAT
from one workbook to another(Add-in)? (or is this just to copy it to a
workbook as I want to copy it to my home copy of excel and for it to be
available in *all* workbooks).

Thanks for your help,

Jason

 

[Jason]

Ignore my last post Ron. I've found the path:

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

That's great. I can just copy it for my home PC

Thanks again.... Good tips on the site as well!

Jason

 

[Ron de Bruin]

It is in the first part
"How do you customize the QAT for all workbooks"

Excel saves your QAT setup in a file named "Excel.qat" and in Win XP you will find it here :
C:\Documents and Settings\<username>\Local Settings\Application Data\Microsoft\OFFICE\Excel.qat

In Vista you can find it here :
C:\Users\<username>\AppData\Local\Microsoft\Office\Excel.qat


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm