#1
|
|||
|
|||
Copy Macros from Word 2003 - Word 2007
I have several people that have macros that were run as a button item from their Word 2003 program. Now they
want to take those macros and have them moved over to Word 2007 and used as a button again. Yes, they are the users of the application. I have found the Macros, but do not understand how to move them over into Word 2007 and save them in the normal.dot file. When I kept looking, there was onlt a normal.dotx file. Tried to rename to normal.dot, but that was not the answer. For one of the macros, I exported them to an output file save as *.bas file. When I went into Word 2007, thought I should havce been able to import the file. When I attempted to do that, there were two subroutines, which was two macros she had on Word 2003. Once I did that it allowd me to run one of them but not both of them. The second one would not execute. I am trying to find a cut to the chase step by step or link for how to get these macros over into Word 2007 and then assign them as buttons. I would appreciate all the help I can get in refernce to this matter. Thanx in advance. Jerry Last edited by ballj_35; 05-03-2011 at 07:07 PM. Reason: Better looking format.\ |
#2
|
||||
|
||||
Hi Jerry,
Probably the easiest way to do this is to open the old Normal.dot template for editing, then save it as a Normal.dotm (ie macro-enabled) template in the new format.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Copy Macros from Woord 2003 - Word 2007
How would I get to the old Normal.dot file? Also, I do see the Normal.dotm file on her machine. How can I get this macro into that Normal.dotm file and then be able to run the macro. I can see the Macro name, but cannot get it over there.
Any ideas? From what I have been reading Word 2007 uses the normal.dotm file instead of normal.dot. If they have already removed Word 2003, where would it be? Thx in advance. Jerry |
#4
|
||||
|
||||
Hi Jerry,
Do you still have the Word 2003 installation? If so, go to Tools|Options|File locations and look under 'User templates' for the path to the file. To see where Word 2007 has its templates stored, go to Word Options|Advanced > General and look under 'User templates' for the path to the file. With any luck, that's the same folder than Word 2003 used. If there's a 'Normal.dotm' there, close Word 2007 and delete or rename it. Then re-start Word 2007 and open Word 2003's 'Normal.dot' file (you'll need to use the 'All Word templates' option for 'Files of Type' and navigate to the folder where 'Normal.dot' is located). You can then save the file as a macro-enabled template type, named 'Normal.dotm', where Word 2007 keeps its user templates. Re-start Word and all your macros should be available, along with whatever other template customizations were in use before.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Copy Macros from Woord 2003 - Word 2007
Plz see the attachment, since I tried to follow the direction given and could still not get to this macro to run it. Thanx in advance.
Jerry |
#6
|
||||
|
||||
Hi Jerry,
Some of the steps documented in your attachment are contrary to what I advised you to do. Also, in Word 2003, when you press Alt-F8, what macros appear there? I note you have two userforms. How are these activated?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
Copy Macros from Woord 2003 - Word 2007
They no longer have Word 2003 installed. What I found was Normal.dot and Normal.dotm in their "..\user templates" folder. This is how I am I was to rename Normal.dotm and the copy normal.dot to that name.
I tried your step by step, that was when I tried to do a 'Save As' and got the dialog box, that I could nnot save a file that was already open. You state: "You can then save the file as a macro-enabled template type, named 'Normal.dotm', where Word 2007 keeps its user templates." Well this is the challenge I found, since Word was telling me 'Normal.dotm' was open. Plz advise. Thanx in advance. |
#8
|
||||
|
||||
Hi Jerry,
Simply renaiming 'Normal.dot' to 'Normal.dotm' is not a good idea. Files with .dot and .dotx/.dotm have a completely different structure. What you could safely do is rename the 'Normal.dot' file to 'Normal.doc' and then open it as an ordinary document. Once you've done that, you should be able to go into the visual basic editor and export all its modules & forms, except for the 'This Document' module, whose contents you should copy directly from 'Normal.doc' into the 'This Document' module for Normal.dotm. You can then close the 'Normal.doc' file and, using the visual basic environment import the code modules & forms into Normal.dotm. Note: if you've been creating code modules in the Normal.dotm file already, they should probably be deleted so that you don't get conflicts when the import is done.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Word document with Macros with trusted locatin versus Word document 1997-2003 | Cardinal2 | Word | 1 | 11-30-2015 07:42 PM |
macros and references in Word 2007 letter | jingles9 | Word | 6 | 09-29-2015 04:52 AM |
copy & paste into Office Word 2003 | oldyeller38 | Word | 1 | 12-18-2014 07:06 PM |
How to identify whether Word 2007 was used to create a document saved as Word 2003 | noviceatwork | Word | 0 | 03-08-2012 06:40 AM |
Word 2007 allows unwanted styles in Word 2003 protected documents | jhopppppp | Word | 0 | 08-09-2010 10:45 AM |