- Joined
- Feb 18, 2002
Some of this may help someone somewhere save some time & aggravation:
Word 2007
• To import a Ribbon consisting of a template from the previous version of Word, simply take the Normal.dot file from the old version of Word and place it in folder
C:\Users\[user name]\AppData\Roaming\Microsoft\Word\STARTUP\
[Previous versions of Word Normal.dot location:
MS Word > Tools > Options > File Locations TAB > User Templates...]
This will result in Add-Ins ribbon loading at startup. However, it may contain unwanted Menu and Toolbar items as well. To make a custom Normal.dot file with just the templates in previous version of Word:
1. Start an older version of Word > Tools > Customize... > Toolbars TAB > New > Make toolbar available: Document1 > OK > Place items inside the newly created toolbar.
2. Save the file as a .doc file (in case it's also needed later) but then File > Save As... > Save As Type: Document Template (*.dot) > Save
3. Copy the .dot file to C:\Users\[user name]\AppData\Roaming\Microsoft\Word\STARTUP\
4. You may have to re-create in Word 2007 any macros you saved, but Classic Template shortcuts for them should then work.
Excel 2007
• To import a Ribbon consisting of a template from the previous version of Excel, convert the old templates into an *.xla Add-In using a previous version of Excel: Tools > Customize... > Toolbars TAB > Attach... > Select and Copy custom toolbars > OK > Close
File > Save As ... > Save as type: Microsoft Office Excel Add-In (*.xla) > Save the file then copy it to
C:\Users\[user name]\AppData\Roaming\Microsoft\Excel\XLSTART\
or
C:\Program Files Vista\Microsoft Office\Office12\XLSTART
Start Excel 2007 which would then show the custom toolbars under the Add-Ins Ribbon. Excel12.xlb containing the Add-In information will also be created in C:\Users\[user name]\AppData\Roaming\Microsoft\Excel\
Install Classic Menus in Office 2007
• Freeware portion of RibbonCustomizer software http://pschmid.net/office2007/ribboncustomizer can be used to get the classic menus installed.
After installing RibbonCustomizer, go to the View Ribbon >
Customize Ribbon (click on its drop down menu, not on its icon) > Customization Schemes >
to get the Classic User Interface enabled
[Classic UI feature can be used indefinitely, without selecting to try the shareware portion of the program so you don't have to select 'Evaluate RibbonCustomizer Professional'. Note that RibbonCustomizer may delay Word Startup Time a little.]
Version 1.2 of RibbonCustomizer lets you use your own custom images as icons on the Ribbon BUT ONLY to your own macro buttons. You cannot assign custom images to regular office commands. Also, files generated with version 1.2 cannot be read by older releases.
Office 2007's own customized icons in the top bar above ribbons
• Office 2007 stores customized templates (customized icons in the top bar above ribbons) in the following files:
Word 2007 Word.qat
Excel 2007 Excel.qat
PowerPoint 2007 PowerPoint.qat
Access 2007 Access.qat
Outlook 2007:
Contacts Olkaddritem.qat
Calendar Olkapptitem.qat
Distribution list Olkdistitem.qat
Journal entry Olklogitem.qat
Mail Olkmailitem.qat
Post in folder Olkpostitem.qat
Tasks Olktaskitem.qat
.QAT files are created after one customized change is made.
Location for Windows Vista: C:\Users\[username]\AppData\Local\Microsoft\Office
Location for Windows XP: C:\Documents and Settings\[username]\Local Settings\Application Data\Microsoft\Office
Default .qat file locations cannot be changed like their equivalents could in previous versions of Office.
Word 2007
• To import a Ribbon consisting of a template from the previous version of Word, simply take the Normal.dot file from the old version of Word and place it in folder
C:\Users\[user name]\AppData\Roaming\Microsoft\Word\STARTUP\
[Previous versions of Word Normal.dot location:
MS Word > Tools > Options > File Locations TAB > User Templates...]
This will result in Add-Ins ribbon loading at startup. However, it may contain unwanted Menu and Toolbar items as well. To make a custom Normal.dot file with just the templates in previous version of Word:
1. Start an older version of Word > Tools > Customize... > Toolbars TAB > New > Make toolbar available: Document1 > OK > Place items inside the newly created toolbar.
2. Save the file as a .doc file (in case it's also needed later) but then File > Save As... > Save As Type: Document Template (*.dot) > Save
3. Copy the .dot file to C:\Users\[user name]\AppData\Roaming\Microsoft\Word\STARTUP\
4. You may have to re-create in Word 2007 any macros you saved, but Classic Template shortcuts for them should then work.
Excel 2007
• To import a Ribbon consisting of a template from the previous version of Excel, convert the old templates into an *.xla Add-In using a previous version of Excel: Tools > Customize... > Toolbars TAB > Attach... > Select and Copy custom toolbars > OK > Close
File > Save As ... > Save as type: Microsoft Office Excel Add-In (*.xla) > Save the file then copy it to
C:\Users\[user name]\AppData\Roaming\Microsoft\Excel\XLSTART\
or
C:\Program Files Vista\Microsoft Office\Office12\XLSTART
Start Excel 2007 which would then show the custom toolbars under the Add-Ins Ribbon. Excel12.xlb containing the Add-In information will also be created in C:\Users\[user name]\AppData\Roaming\Microsoft\Excel\
Install Classic Menus in Office 2007
• Freeware portion of RibbonCustomizer software http://pschmid.net/office2007/ribboncustomizer can be used to get the classic menus installed.
After installing RibbonCustomizer, go to the View Ribbon >
Customize Ribbon (click on its drop down menu, not on its icon) > Customization Schemes >
to get the Classic User Interface enabled
[Classic UI feature can be used indefinitely, without selecting to try the shareware portion of the program so you don't have to select 'Evaluate RibbonCustomizer Professional'. Note that RibbonCustomizer may delay Word Startup Time a little.]
Version 1.2 of RibbonCustomizer lets you use your own custom images as icons on the Ribbon BUT ONLY to your own macro buttons. You cannot assign custom images to regular office commands. Also, files generated with version 1.2 cannot be read by older releases.
Office 2007's own customized icons in the top bar above ribbons
• Office 2007 stores customized templates (customized icons in the top bar above ribbons) in the following files:
Word 2007 Word.qat
Excel 2007 Excel.qat
PowerPoint 2007 PowerPoint.qat
Access 2007 Access.qat
Outlook 2007:
Contacts Olkaddritem.qat
Calendar Olkapptitem.qat
Distribution list Olkdistitem.qat
Journal entry Olklogitem.qat
Mail Olkmailitem.qat
Post in folder Olkpostitem.qat
Tasks Olktaskitem.qat
.QAT files are created after one customized change is made.
Location for Windows Vista: C:\Users\[username]\AppData\Local\Microsoft\Office
Location for Windows XP: C:\Documents and Settings\[username]\Local Settings\Application Data\Microsoft\Office
Default .qat file locations cannot be changed like their equivalents could in previous versions of Office.
