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

Searching for Optional Hyphens

If you have a document that contains optional hyphens (special characters that mark where a word can be split between ...

Discover More

Reorganizing Data

If you need to consolidate a single column of data into multiple columns of data, you'll love this macro. It provides a ...

Discover More

Turning Off a Startup Sound

If you hear a sound when you start Word, it is because of some settings within Windows itself. You can use the Control ...

Discover More

The First and Last Word on Word! Bestselling For Dummies author Dan Gookin puts his usual fun and friendly candor back to work to show you how to navigate Word 2013. Spend more time working and less time trying to figure it all out! Check out Word 2013 For Dummies today!

More WordTips (menu)

Working on Shared Templates

In many companies it is common to have standard templates accessible through the internal network. If you have templates ...

Discover More

Creating a Boilerplate Document

If you have several boilerplate documents you need to routinely use in Word, then you should learn how to use templates. ...

Discover More

Batch Template Changes

Changing the template associated with a couple of documents is easy, but what if a whole directory needs to be changed? ...

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 three more than 5?

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.