I want to bring over my QATs created in Office 2007 (running in Windows XP Pro) into Office 2010 (running in Windows 7 Pro). Because there is no way to export the Office 2007 QATs to a file, I can't do the normal importing a customization file directly from within Office 2010. However, if I copy my word.qat (or excel.qat, powerpoint.qat, etc) file created in Office 2007 over to the appropriate folder in Office 2010, and just change the file extension from ".qat" to ".officeUI" it brings up my QAT settings in Office 2007. It looks okay and seems to function properly like this.

I think this will work, but I'm not sure if it will cause other problems. It seems to look okay. Will I run into trouble with it later?

Hi,

I guess your method is all right. I have try it on my side, it works OK too. So I think you can use it.

• Marked as answer by Jennifer Zhan Wednesday, June 30, 2010 1:14 AM

Hi,

I guess your method is all right. I have try it on my side, it works OK too. So I think you can use it.

• Marked as answer by Jennifer Zhan Wednesday, June 30, 2010 1:14 AM

I want to bring over my QATs created in Office 2007 (running in Windows XP Pro) into Office 2010 (running in Windows 7 Pro). Because there is no way to export the Office 2007 QATs to a file, I can't do the normal importing a customization file directly from within Office 2010. However, if I copy my word.qat (or excel.qat, powerpoint.qat, etc) file created in Office 2007 over to the appropriate folder in Office 2010, and just change the file extension from ".qat" to ".officeUI" it brings up my QAT settings in Office 2007. It looks okay and seems to function properly like this.

I think this will work, but I'm not sure if it will cause other problems. It seems to look okay. Will I run into trouble with it later?

Sorry to bump such an old thread... but I couldn't find anything about a possible 2007 > 2013 migration.  The strict change in extension names doesn't enable the old .qat file to be imported (in MSO2013 the new extension is .exportedUI) -- however, digging into the old .qat and new .exportedUI files, it seems all I needed to do was add <mso: cmd app="Word" dt="0" /> to the start of the file and presto... imported without any problems.  Let's see if it all runs fine... (and if it works in Excel too) (phew!)

What do you by add to the start?

Hi, I just used this last method to import an Excel 2003 .qat file into Excel 2010.  Detailed instructions below:

1. Rename the file from filename.qat to filename.exportedui
2. Open the file in Notepad
3. Add the text <mso: cmd app="Excel" dt="0" /> at the start of the file, including the <>and save it.
4. You should now be able to import this into Excel 2010 and see your customisations.

• Edited by EmTang Wednesday, June 19, 2013 10:57 AM clarity

Hi, I just used this last method to import an Excel 2003 .qat file into Excel 2010.  Detailed instructions below:

1. Rename the file from filename.qat to filename.exportedui
2. Open the file in Notepad
3. Add the text <mso: cmd app="Excel" dt="0" /> at the start of the file, including the <>and save it.
4. You should now be able to import this into Excel 2010 and see your customisations.

• Edited by EmTang Wednesday, June 19, 2013 10:57 AM clarity

Thank You so much for this work-around/fix - did that excel one in both word & excel. Tried excel 1st and hey presto there were my old toolbar settings. Then tried word and it didn't work (didn't notice that the statement being added pointed to excel). Redid the command line - which I copied from your post about word and it too worked like a charm. Once again thank you so much - didn't want to have to start again and create my toolbar items which I use as shortcuts all the time. Made upgrading from Office 2007 to Office 2013 much less bothersome. Took me a little time to find your post but was definitely worth digging for. ONCE AGAIN - THANKS SO VERY MUCH>

I've already posted this comment in your Word work around but thought it might save some novices time to post it in your Excel - life saving assistance. Thank You so much for this work-around/fix - did that excel one in both word & excel. Tried excel 1st and hey presto there were my old toolbar settings. Then tried word and it didn't work (didn't notice that the statement being added pointed to excel). Redid the command line - which I copied from your post about word and it too worked like a charm. Once again thank you so much - didn't want to have to start again and create my toolbar items which I use as shortcuts all the time. Made upgrading from Office 2007 to Office 2013 much less bothersome. Took me a little time to find your post but was definitely worth digging for. ONCE AGAIN - THANKS SO VERY MUCH

Thank you!  I got a new machine, and saved my .qat files, but couldn't get them to work in Office 2013.  At last, I find here the answer! I inserted the text above (and changed the extension) and it worked!

Why is it so hard to find information like this?

• Edited by Brianrhicks 5 hours 34 minutes ago

Thank you!  I got a new machine, and saved my .qat files, but couldn't get them to work in Office 2013.  At last, I find here the answer! I inserted the text above (and changed the extension) and it worked!

Why is it so hard to find information like this?

• Edited by Brianrhicks Monday, April 20, 2015 1:56 AM

Hi, I just used this last method to import an Excel 2003 .qat file into Excel 2010.  Detailed instructions below:

1. Rename the file from filename.qat to filename.exportedui
2. Open the file in Notepad
3. Add the text <mso: cmd app="Excel" dt="0" /> at the start of the file, including the <>and save it.
4. You should now be able to import this into Excel 2010 and see your customisations.

I need to copy my exported 2010 QAT back into Excel 2007. Would the above method work there? Would the text given in step 3 need changing?