Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-14-2012, 03:20 AM
cartoonist cartoonist is offline Transferring auto text and macros from one computer to another Windows 7 64bit Transferring auto text and macros from one computer to another Office XP
Novice
Transferring auto text and macros from one computer to another
 
Join Date: Aug 2012
Posts: 2
cartoonist is on a distinguished road
Default Transferring auto text and macros from one computer to another

Hi,



Regrettably I'm not technically minded, and need help with this. I bought a new computer with Win7 as the OS and Microsoft Office 2010. My old computer system was XP and Word 2003.

I have been trying to find a way of transferring my macros and auto text entries from the old computer to the new but without success. I "googled" it but the answers were far too technical for me.

I wonder if anyone on the forum knows an easy way?

Thanks in advance.
Reply With Quote
  #2  
Old 08-14-2012, 03:24 AM
Stefan Blom's Avatar
Stefan Blom Stefan Blom is offline Transferring auto text and macros from one computer to another Windows 7 64bit Transferring auto text and macros from one computer to another Office 2010 32bit
Moderator
 
Join Date: Aug 2011
Posts: 3,871
Stefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to all
Default

On your old computer, find Normal.dot (which is the default save location for both macros and AutoText entries in Word 97-2003). Make a renamed copy and put it in Word's Startup folder on your new machine. (By default, the Startup folder for Word 2010 on Windows 7 is C:\Users\your_user_name_here\AppData\Roaming\Micro soft\Word\Startup.)
__________________
Stefan Blom
Microsoft Word MVP

Microsoft 365 apps for business
Windows 11 Professional
Reply With Quote
  #3  
Old 08-14-2012, 03:32 AM
cartoonist cartoonist is offline Transferring auto text and macros from one computer to another Windows 7 64bit Transferring auto text and macros from one computer to another Office XP
Novice
Transferring auto text and macros from one computer to another
 
Join Date: Aug 2012
Posts: 2
cartoonist is on a distinguished road
Default Auto text

Many thanks, Stefan. I'll try that now.

Regards,

Ron
Reply With Quote
  #4  
Old 08-14-2012, 11:16 AM
Endzone Endzone is offline Transferring auto text and macros from one computer to another Windows XP Transferring auto text and macros from one computer to another Office 2003
Novice
 
Join Date: Aug 2012
Posts: 21
Endzone is on a distinguished road
Default

In windows XP go to My Computer/Control Panel. Then click on Folder Options. Then click on View and select "Show hidden files & folder".

Then go to C:\Documents & Settings\your_user_name\Application Data\Microsoft\Templates. There you will find the normal file along with any other templates.

I would just copy them all and paste them into the corresponding folder in Word 2010. I'm not sure why you were told to rename the normal file or to put it in a startup folder. Maybe Word 2010 does not have the same directories that Word 2003 does. But in word 2003, it will only recognize the normal.dot file as the default template which includes your macros. If you rename it to something as normal.old, word will not recognize it--at least it won't in Word 2003.
Reply With Quote
  #5  
Old 08-14-2012, 12:46 PM
Charles Kenyon Charles Kenyon is offline Transferring auto text and macros from one computer to another Windows Vista Transferring auto text and macros from one computer to another Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by Endzone View Post
In windows XP go to My Computer/Control Panel. Then click on Folder Options. Then click on View and select "Show hidden files & folder".

Then go to C:\Documents & Settings\your_user_name\Application Data\Microsoft\Templates. There you will find the normal file along with any other templates.

I would just copy them all and paste them into the corresponding folder in Word 2010. I'm not sure why you were told to rename the normal file or to put it in a startup folder. Maybe Word 2010 does not have the same directories that Word 2003 does. But in word 2003, it will only recognize the normal.dot file as the default template which includes your macros. If you rename it to something as normal.old, word will not recognize it--at least it won't in Word 2003.
Word 2003 and 2010 use different file structures. You do not want to use a Word 2003 normal.dot as a Word 2010 normal.dotm. It will cause problems.

You rename the normal.dot to avoid confusion. A good name would be normal2003.dot. If it is placed in the Word Startup Folder all AutoText and macros in it will be available to every document.

To original poster: You may want to use Greg Maxey's building blocks utility to move the AutoText from your old normal.dot to your new normal.dotm. That way you will be able to use the pop-up tool-tips for the AutoText. Building Blocks & AutoText
I know that this isn't the simplicity you asked for. The first instructions you got from Stefan are the best simple instructions you are likely to find.
Reply With Quote
  #6  
Old 08-14-2012, 10:22 PM
Endzone Endzone is offline Transferring auto text and macros from one computer to another Windows XP Transferring auto text and macros from one computer to another Office 2003
Novice
 
Join Date: Aug 2012
Posts: 21
Endzone is on a distinguished road
Default

I think it's a good idea to make a copy of the normal.dot file or whatever its equivalent is in word 2010. Mine got corrupted somehow, and I had to redo the macros. If it ever goes bad, just delete it out of there and pop in the copied file in its place. Would that work?
Reply With Quote
  #7  
Old 08-15-2012, 02:36 AM
Stefan Blom's Avatar
Stefan Blom Stefan Blom is offline Transferring auto text and macros from one computer to another Windows 7 64bit Transferring auto text and macros from one computer to another Office 2010 32bit
Moderator
 
Join Date: Aug 2011
Posts: 3,871
Stefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to allStefan Blom is a name known to all
Default

Making a backup of Normal is always a good idea. But you can't replace Normal.dotm in Word 2007/2010 with Normal.dot of older versions.
__________________
Stefan Blom
Microsoft Word MVP

Microsoft 365 apps for business
Windows 11 Professional
Reply With Quote
  #8  
Old 08-15-2012, 12:36 PM
Charles Kenyon Charles Kenyon is offline Transferring auto text and macros from one computer to another Windows Vista Transferring auto text and macros from one computer to another Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by Endzone View Post
I think it's a good idea to make a copy of the normal.dot file or whatever its equivalent is in word 2010. Mine got corrupted somehow, and I had to redo the macros. If it ever goes bad, just delete it out of there and pop in the copied file in its place. Would that work?
A backup of your customizations is a very good idea. They are not all stored in normal.dot, though! Here is a list for Word 2007 & 2010: https://www.msofficeforums.com/word/...locations.html
For Word 2003 see What Files Do I Need to Backup? (or where does Word store all my customizations?) by Dave Rado, MVP and Brenda Hutton

You can also store your macros and many customizations in a different global template so you don't have to worry about normal.dot having to be reset. This is also a better way to share customizations with others. You would want a backup of that file.

Again, you can't transfer the normal.dot file directly from Word 2003 to a later version. You can use it, you just can't use it to replace normal.dotm.
Reply With Quote
  #9  
Old 08-15-2012, 01:00 PM
Endzone Endzone is offline Transferring auto text and macros from one computer to another Windows XP Transferring auto text and macros from one computer to another Office 2003
Novice
 
Join Date: Aug 2012
Posts: 21
Endzone is on a distinguished road
Default

Quote:
Originally Posted by Charles Kenyon View Post
A backup of your customizations is a very good idea. They are not all stored in normal.dot, though! Here is a list for Word 2007 & 2010: https://www.msofficeforums.com/word/...locations.html
For Word 2003 see What Files Do I Need to Backup? (or where does Word store all my customizations?) by Dave Rado, MVP and Brenda Hutton

You can also store your macros and many customizations in a different global template so you don't have to worry about normal.dot having to be reset. This is also a better way to share customizations with others. You would want a backup of that file.

Again, you can't transfer the normal.dot file directly from Word 2003 to a later version. You can use it, you just can't use it to replace normal.dotm.
Thanks for that link. I actually found that doing a Google search. I did go to Tools\Options\Save and check the box to prompt to save the normal.dot file. I think all my templates though are in App Data\Microsoft\templates. Here's the folder. I don't know of any other templates I have. The macros were the most work, and I believe they are in the normal.dot file. I do have a couple of letter templates, but they are stored in the same place as all my letter files. The template was not saved as a template either. I just make a macro to open the template (file) and insert the date automatically. I guess I did that wrong huh? It can get pretty confusing. I set the template (regular file) to promp for read only though. Then there is a global template. I only use style sheets on certain documents. I'm a rookie, and home use is all I need. If I worked in an office doing this all day long, I would learn much more about it. Apologies for hijacking the thread.



Thanks for the assistance.
Reply With Quote
  #10  
Old 08-15-2012, 02:53 PM
Charles Kenyon Charles Kenyon is offline Transferring auto text and macros from one computer to another Windows Vista Transferring auto text and macros from one computer to another Office 2010 32bit
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,081
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

If you are using Word more than 6 hours a month you owe it to yourself to learn to use Styles in Word. Within two months you will more than have recovered any time you spend learning them. If you use Word more than that the savings are much more dramatic. See Understanding Styles in Microsoft Word, Tips for Understanding Styles in Word and Yet Another "Use Styles" Verbal Beating!

Save your letterhead as a template in your templates folder. Put the date in using a CreateDate field. When you use it for a new letter, the new date will automatically be inserted and it will stay that date in your saved letter.
Templates in Microsoft Word
Using Date Fields in Microsoft Word
Reply With Quote
  #11  
Old 08-15-2012, 04:01 PM
Endzone Endzone is offline Transferring auto text and macros from one computer to another Windows XP Transferring auto text and macros from one computer to another Office 2003
Novice
 
Join Date: Aug 2012
Posts: 21
Endzone is on a distinguished road
Default

Quote:
Originally Posted by Charles Kenyon View Post
If you are using Word more than 6 hours a month you owe it to yourself to learn to use Styles in Word. Within two months you will more than have recovered any time you spend learning them. If you use Word more than that the savings are much more dramatic. See Understanding Styles in Microsoft Word, Tips for Understanding Styles in Word and Yet Another "Use Styles" Verbal Beating!

Save your letterhead as a template in your templates folder. Put the date in using a CreateDate field. When you use it for a new letter, the new date will automatically be inserted and it will stay that date in your saved letter.
Templates in Microsoft Word
Using Date Fields in Microsoft Word
Thanks Charles. I know it would do me a world of good to read those articles.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
the saveas macro in excel 2010 is not transferring the macros to the new workbook missmr28 Excel Programming 3 06-20-2012 05:30 AM
Auto Text PineJ Office 1 03-21-2012 12:43 AM
Transferring auto text and macros from one computer to another Eliminating Text Wrapping Via Macros LADeveloper Word 3 11-13-2011 12:55 AM
Computer Stolen-Install Office 2007 On New Computer corndale Office 0 08-23-2010 09:52 AM
Looping macros to add text to beginning and end of a paragraph pachmarhi Word VBA 0 02-16-2009 06:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:50 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft