Hello gooddog,
Thank you for your question
ALthough I have done this previously in other versions of Word, I was
surprised how difficult it was to find comprehensive directions. Also
note, that in my experience MOST Word macros have worked across
different versions of Word, however some did not and some required
minor editing of the macro to function properly - such as changing the
paths to files.
Searching "microsoft word" +export +macro -virus, I found the
following on Google Groups that should help you transfer your macros:
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=u%23d2cyaqAHA.2132%40tkmsftngp02&rnum=25&prev=/groups%3Fq%3D%2522microsoft%2Bword%2522%2B%252Bexport%2B%252Bmacro%2B-virus%26hl%3Den%26lr%3D%26ie%3DUTF-8%26selm%3Du%2523d2cyaqAHA.2132%2540tkmsftngp02%26rnum%3D25
"I am new to Word. I have a pc with Word 2000 at my office. On this
machine I recorded a macro, which to my surprise seemed to be a sort
of visual Basic coding language.
The program runs OK but now I want it to work on another computer
which only runs Word 97.
How do I transfer the VB file to this PC? I do not understand where
the VB-code or the macro is saved to..."
Although this person is wishing to go in the opposite direction you
desire, the answer is appropriate for your question as well:
"...The macros actually get stored in you Normal.dot. If you have a
home directory on the network and store you Normal.dot there it will
be accessible from any computer that you choose to use it from. As
network administrator in my office I by default point the each group
to a read only directory for work group macros. This is set by going
to tools-> options->
file locations. You will see there word set the location for the
files that it uses. I set the startup directory for each work group
and place my work group macro in that directory. On my network the
directory is M:\JSstart and the work group macro is called
JSNormal.dot. When word is accessed that
is one of the first things Words does is load those macros. You will
note that you also have a user template directory this where macros
that users create get stored, in their Normal.dot.
I have chosen this method to share macros. Some of the macros that I
use at work access my sql data and pre fill templates. I hope that
this answers your questions..."
This is true, but perhaps not complete. While *most* Word macros are
stored in normal.dot, not all are if you have previously chosen to
save a macro in another template. If all of yours are, simply rename
normal.dot on your new machine to keep a copy of the default
normal.dot installed with this version of Word "in case" it is needed,
and copy your previous normal.dot to the proper directory. You can
search you machine with "find files" to see where normal.dot is
installed, and rename it to normal.old, for example, prior to copying
the macro rich normal.dot from your Word 97 installation.
The replies continue with an excellent solution by Charles Kenyon:
"...What follows are instructions I wrote for someone else but they
may help:
To move your macros (and custom toolbars) to a global template...open
the template or create a new document based on the template. If you
don't already have a global template, go to File => New and click "New
Template" in the bottom right corner of the dialog box.
Select blank document. You can use this document to keep notes on what
you have done if you want. Save it using a name like "MyGlobal.dot."
Don't close it.
Use the Organizer:
(Tools => Templates and Add-Ins... => Organizer (button) => Macro
Project Items (tab)) to move it.
Probably, the macros will be in the Macro Module "New Macros." in
Normal.dot. If you already have a Module named "New Macros" in your
template, rename it for now so you can copy the Module from Normal.dot
to your template. If there are other modules in Normal.dot you want to
copy those as well.
Then close the Organizer and save your template.
Use the VBA Editor (Alt-F11) to look at the New Macros module in your
template (not the one in Normal.dot). You should be able to spot the
macros that you use. Delete any other macros and Ctrl-S to save your
changes to the Template. If you already had macros in your template
and had to rename "New Macros," double-click on that module. For now,
you will want to move all the macros to your new "New Macros" module.
Then right-click on the Module that used to be "New Macros" and remove
it. It will ask you if you want to export first; answer: No. With your
insertion point back in the New Macros module of your template, press
Ctrl-S to again save your template.
Then double click on the Module "New Macros" in Normal.dot and delete
the macros that you transferred to your template. Ctrl-S to save your
changes to Normal.dot.
If you have toolbars that you want to move, copy those as well, after
you have copied any macros that the toolbars call. Styles won't do you
much good in a global template. If you need to move those as well,
write back and we'll get into it.
Save and close your global template.
For toolbars, Open a new blank document. Tools => Customize =>
Toolbars (1st Tab) and check your toolbars. Right-click on the
selection and rename it xxx Old Toolbar. (We are doing this before
deleting it. Want to check if new toolbar works and can't really do
that without changing the name.) Close the
Customize dialog box.
Create a new document from your template. File => New... Check to see
if your toolbars and macros function the way you want them to. Type
something in the document and then close it without saving it. You
should be prompted as to whether your want to save the changes made to
MyGlobal.dot. Answer
"Yes."
Assuming that your toolbars and macros function properly, you can now
use Tools => Customize (this time customizing Normal.dot) to delete
"Anne's Old Toolbar." Quit Word and save your changes to Normal.dot.
Next time, when you create a toolbar using the Customize command under
the Tools menu, or Tools = Macros... to record a macro, check to make
sure that it is being saved in the template that will be using it
rather than in Normal.dot. Likewise, make sure that any changes you
make to that toolbar or macro get saved in the template.
This way, if you pass your template on to someone else, they will have
the benefit of your toolbar and macros.
You must have hit a hot button for me on this. Whew!
See: Template Basics:
http://www.addbalance.com/usersguide/templates.htm for
more on templates (user and workgroup), global templates and
Normal.dot."
So, you can use these instructions to create a new template with all
of the macros from your Word 97 installation, copy the template to
your Word 2000 installation and then us e the organizer to copy all of
the macros from this template to the normal.dot of the new
installation.
You might also wish to read the following article at Microsoft
Knowledgebase:
http://support.microsoft.com/default.aspx?scid=kb;en-us;209214
WD2000: How to Rename, Copy, or Delete a Macro
I trust my research has provided the answer you require. If a link
above should fail to work or anything require further explanation or
research, please do post a Request for Clarification prior to rating
the answer and closing the question and I will be pleased to assist
further.
Regards,
-=clouseau=- |
Clarification of Answer by
clouseau-ga
on
11 Apr 2003 08:14 PDT
Hi Kathy,
A couple of thoughts:
1. You might need something larger than a floppy. My normal.dot is
*just* small enough to fit on a floppy. Your might be and may need a
zip or CD. Or to be zipped first. You will have to see the size of
this template which will depend on how many macros are installed
there, etc.
2. Have you tried JUST moving normal.dot to the new machine yet to see
if everything you desire is there? Might be surprising that all
macros, toolbars, etc you wish will show up with only this move. May
not, of course, but worth a first try.
3. I am almost positive that the autocorrect entries also live in
normal.dot. If there is any difficulty moving yours, let me know and
I'll check further to be sure.
4. The only toolbars that you can rename are the one's you have
created. Clicking those, not any of the "built-in" toolbars, allows
them to be renamed. If you have not created any custom toolbars, you
will only be able to move the settings that are kept in normal.dot.
Do let me know how this progresses and I will be happy to help further
to be sure this goes the way you desire.
Regards,
-=clouseau=-
|
Request for Answer Clarification by
gooddog-ga
on
11 Apr 2003 10:26 PDT
Hello Clouseau,
Thanks for the clarification on the toolbars, as time permits this
morning I am continuing my efforts to work on this.
I won't have both computers simultaneously--the scenario is that some
morning I will come to work and as if by magic, will have a new
computer. (This is in a clinic associated with a hospital, all the
clinics are upgrading, mine is to be the last. The first clinic had
no warning, staff just came in one day to find their old computers and
data gone, none of it transferred, and unfortunately, they had not
backed up files recently...I am trying to avoid that scenario myself,
but have been unable to determine just when the new computer will
appear, other than "sometime between now and June 1st".)
A floppy is my only option to move things--the machine doesn't have CD
writing capabilities, nor a zip program, and it's against the rules to
add any peripherals or programs, so I'm hoping to be able to squeeze
it onto a diskette--I can jettison some of my macros if need be.
After looking at some of the links you posted, I think you are right,
that the autocorrect entries will move in normal.dot.
Again, thank you for your time and effort.
Kathy
|
,
0 Comments
)