Recovering Macros and AutoText Entries from Normal.dot

by Allen Wyatt
(last updated June 30, 2014)

2

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

Cut and Paste Formatting

What happens when you copy information from one document and paste it into another? It is possible for what you paste to ...

Discover More

Returning the MODE of a Range

The MODE function is used to determine the most frequently recurring value in a range. This tip explains how to use the ...

Discover More

Highlighting Text Using the Keyboard Only

Highlighting text, using the Highlight tool, is a great way to mark up a document. Normally you need to use the toolbar ...

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)

Saving a Preview with Your Template

Templates provide a collection of styles and boilerplate for new documents. Selecting the right template by filename only ...

Discover More

Word Won't Take 'No' for an Answer

If you choose to exit Word and it asks you if you want to save changes to your Normal.dot template, it can be very ...

Discover More

Updating Many Template References

Documents rely on templates. If you change the location of those templates (on purpose or by accident), Word can take a ...

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. Maximum image size is 6Mpixels. 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 nine minus 2?

2019-01-19 22:20:13

Richard Ong

This was very helpful. I've always stumbled when it comes to transferring macros, styles, and autocorrect entries (covered in your "Backing Up Your AutoCorrect Entries").

I exported my macros from Normal.dot to a BAS file. Copied that file to a thumb drive. Moved the thumb drive to my new desktop and imported the file when I opened my Visual Basic editor from a blank document opened in my Word 2007 application. (My old machine has Word 2003 on it so this and the other transfers worked fine going from Word 2003 to Word 2007.)

I then copied the macros to the new Word 2007 Normal template using organizer. If I remember correctly.

I then made a copy of my Word 2003 Normal template, renamed it from Normal.dot to "2003template.doc", copied it to the thumb drive, open the "doc" file, and transferred the styles to the new Word 2007 Normal template using the organizer.

I never use the Autotext feature so I ignored that.

I searched for all the autocorrect files you describe in your other article and there about 14 such files (*.ACL). I am mostly concerned about transferring my Autocorrect entries for Word so in Word 2003 I added an entry to my Autocorrect entries and then exited from that window. I searched again for all the *.ACL files on the Word 2003 system and noted which one was time stamped just a minute or so prior. For Word 2003, this file was MSO1033 in C:\Users\User-Name\Appdata\Roaming\Microsoft\Office. I copied this to the other computer as before and renamed the MSO1033.ACL file in that same directory and then copied my MS)1033.ACL file from the old computer to the above-described directory (all with Word 2007 being closed).

Check the list of Autocorrect entries after restarting Word 2007, I found my Word 2003 list nice as you please.


2018-12-11 07:22:59

V.S.Rawat

>This tip (210) applies to Microsoft Word 97, 2000, 2002, and 2003.

What about further versions, say 2016?

no method is available?

Thanks.


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.