Copying Custimzed toolbars


J

Jim

I have 2007 installed on my machine. I am getting a new PC, but have several
customized toolbars in Excel and Word. How do I successfully tranfer them
from one PC to the next?

Jim
 
Ad

Advertisements

R

Ron de Bruin

Hi Jim

There are no toolbars in 2007
Do you mean that you want to copy your QAT to the new machine ?
 
J

Jim

Yes....I need to copy the QAT...thanks..

Ron de Bruin said:
Hi Jim

There are no toolbars in 2007
Do you mean that you want to copy your QAT to the new machine ?
 
R

Ron de Bruin

Hi Jim

Excel saves your QAT setup in a file named “Excel.qat†in:
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

Note: This file will not exist if you have not customized your QAT

For Word it is word.qat

Copy this file in the correct location on the new machine
There is more Ribbon/QAT info on my site in this section
"Excel 2007 Ribbon and QAT pages"
 
Ad

Advertisements

J

Jim

Thanks for your help Ron.

Ron de Bruin said:
Hi Jim

Excel saves your QAT setup in a file named “Excel.qat†in:
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

Note: This file will not exist if you have not customized your QAT

For Word it is word.qat

Copy this file in the correct location on the new machine
There is more Ribbon/QAT info on my site in this section
"Excel 2007 Ribbon and QAT pages"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top