Recovering Macros and AutoText Entries from Normal.dot

by Allen Wyatt
(last updated June 30, 2014)

Walt Otterson keeps running into a problem trying to transfer macros and AutoText entries from his old version of Word to his new version. The old version of Word (2000) is no longer available, but he has the Normal.dot file from that version, and he's trying to use the Organizer in Word 2002 to transfer the macros and entries. Every time he tries, Word hangs and he needs to reboot.

There are a couple of things you could try in order to recover what you need. First of all, you could locate someone else with a Word 2000 system who would let you run some tests. Find their Normal.dot file and, outside of Word, rename it to something else. Then, copy your old Normal.dot into the same folder where their renamed Normal.dot resides. Start Word 2000, and see if you can view the macros in the VBA Editor. If so, you can export the macros (File | Export Files) to save the macros as a .BAS file.

As for the AutoText entries, on your friend's system use Organizer to copy the entries to a brand new template file. (AutoText entries cannot be attached to documents; they must be moved in the Organizer from one template to another.)

Now, copy the .BAS file and the new template file to your new Word 2002 system. Use the VBA Editor to import the macros (File | Import Files) to the new Normal.dot file. Use the Organizer to transfer the AutoText entries to the new Normal.dot file.

Another thing to try is to make a copy of the old Normal.dot file (the one from your Word 2000 system) and rename the file as a regular document. Open the file and use the Organizer to copy the macros to the new Normal.dot file. You won't be able to copy the AutoText entries in this way, but if you are successful in copying the macros, you can delete the macros from the document (the one that used to be Normal.dot), save the file, and then rename it back to a template file. Start Word 2002 and try, once again, to transfer the AutoText entries from the modified template file to the new Normal.dot file.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (210) applies to Microsoft Word 97, 2000, 2002, and 2003.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Formatting Footnotes and Endnotes

Footnotes and endnotes can be formatted in the same way that you format regular text in your document. There is an easier way ...

Discover More

Shortcut for Selecting a Data Range

Want to select all the data in a contiguous section of a worksheet? The shortcut discussed in this tip makes it very easy.

Discover More

Counting Only Money Winners

If a series of cells contain the amount of money won by individuals, you may want to count the number of individuals who ...

Discover More

Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!

More WordTips (menu)

Opening a Template

If you have a template stored on disk, you can open it and make changes to it just as you do other documents. This tip ...

Discover More

Preventing Changes to Styles in Documents

Have you ever created a template only to have the styles within it changed as they were used within a document? Here are some ...

Discover More

Changing the Attached Template

Templates, when attached to a document, can greatly affect how that document looks. You can change from one template to ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 0 + 7?

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)


This Site

Got a version of Word that uses the menu interface (Word 97, Word 2000, Word 2002, or Word 2003)? This site is for you! If you use a later version of Word, visit our WordTips site focusing on the ribbon interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.