how to export macros
Page 1 of 1•
how to export macros
by fatguy on Fri 25 Jan 2008, 2:38 pm
How can I export a macro that I’ve created in ms Word 97 on my Windows 98 PC to another computer with XP?
Re: how to export macros
by Doctor Inferno on Fri 25 Jan 2008, 4:09 pm
Macros are stored in one of two places – and you decide where and when you create one. When you select Tools -> Macro -> Record New Macro you’re prompted to either create the macro in the global template (normal.dot) file, or the document you’re currently working on – by default, normal.dot is selected so that the macros are available in all documents you create.
Your normal.dot file is also where all custom styles, toolbars and autotext entries are stored, and it’s possible to transfer all of these – plus your macros – from one machine to another courtesy of Word’s Macro Organizer tool. The walkthrough below explains how to access it and back up your macros to a file you then transfer to your second PC before copying those macros into the normal.dot file on that computer so the macros are accessible from there too.
While this tool is the best way to transfer macros, or other individual elements of your normal.dot file (just select the appropriate tab to transfer styles, toolbars and autotext entries in exactly the same way), if you’re migrating to another PC you may wish to take all your settings with you. If you have Office 2000 or later you can use the Save My Settings Wizard to back up all your Office customisations – including the normal.dot template – and then use the same wizard on your new computer to restore them to the version of Office installed there.
Office XP and 2003 users will find the tool installed with Office – access it from the Microsoft Office Tools menu on the Start -> All Programs menu; Office 2000 users need to download it from http://support.microsoft.com/kb/816003/. It’s called the Microsoft Office 2000 Profile Wizard here.
1. Launch Word and create a new document. Save it with the name macro_backup.
Now select Tools -> Macro -> Macros and click the Organizer button. This will launch the Macro Organizer Tool.
2. By default macro_backup should be selected in the left-hand window and the normal.dot template in the right. If this isn’t so, just pick them from each drop-down menu. Select the macros entry in the right-hand window and click Copy.
3. The macros will be copied to macro_backup, so click Close, save the document and transfer it to your other PC. Now launch Word on that PC and repeat steps one and two. This time select the macros in the left-hand window then click Copy.
Your normal.dot file is also where all custom styles, toolbars and autotext entries are stored, and it’s possible to transfer all of these – plus your macros – from one machine to another courtesy of Word’s Macro Organizer tool. The walkthrough below explains how to access it and back up your macros to a file you then transfer to your second PC before copying those macros into the normal.dot file on that computer so the macros are accessible from there too.
While this tool is the best way to transfer macros, or other individual elements of your normal.dot file (just select the appropriate tab to transfer styles, toolbars and autotext entries in exactly the same way), if you’re migrating to another PC you may wish to take all your settings with you. If you have Office 2000 or later you can use the Save My Settings Wizard to back up all your Office customisations – including the normal.dot template – and then use the same wizard on your new computer to restore them to the version of Office installed there.
Office XP and 2003 users will find the tool installed with Office – access it from the Microsoft Office Tools menu on the Start -> All Programs menu; Office 2000 users need to download it from http://support.microsoft.com/kb/816003/. It’s called the Microsoft Office 2000 Profile Wizard here.
1. Launch Word and create a new document. Save it with the name macro_backup.
Now select Tools -> Macro -> Macros and click the Organizer button. This will launch the Macro Organizer Tool.
2. By default macro_backup should be selected in the left-hand window and the normal.dot template in the right. If this isn’t so, just pick them from each drop-down menu. Select the macros entry in the right-hand window and click Copy.
3. The macros will be copied to macro_backup, so click Close, save the document and transfer it to your other PC. Now launch Word on that PC and repeat steps one and two. This time select the macros in the left-hand window then click Copy.
