Exporting a macro from one PC to another - advice appreciated

[Bert Coules]

I'm using Word 2000 and some years ago I had a programmer write me a
custom-designed utility (I've called it a macro in the subject heading, but
I'm not well up on these things and I suppose it might well not be). I
installed it using his instructions (long since lost, alas), and it's called
into operation from the Tools menu.

I'd like to install it again on a new PC, but haven't the faintest idea how
to go about it. Any advice (or a pointer in the right direction for advice)
would be greatly appreciated.

Many thanks,

Bert

 

[Suzanne S. Barnhill]

1. In a new Blank Document (based on Normal.dot), open Tools | Macro |
Macros. If your utility is a macro (which it almost certainly is), you can
probably find it in the list there. Most likely the name of the macro will
be the same as the listing on the Tools menu.

2. Once you have established that it is a macro, click on Organizer... in
the Macros dialog. If, as is likely, the macro is saved in Normal.dot,
you'll see it listed on the right.

3. Select it and click the <<Copy button to copy it into your document. Save
the document.

4. Copy the document to a flash drive (or other removable media) and, from
there, copy it to the HD of your new PC.

5. Open the document in Word on the new PC, open the Organizer, and copy the
macro into Normal.dot.

6. Close the Organizer and go to Tools | Customize | Commands.

7. Select Macros in the Categories list.

8. In the Macros list, find and select your macro and drag it to the Tools
menu.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

 

[Bert Coules]

Brilliant, thanks, Suzanne.

Bert

 

[Suzanne S. Barnhill]

I'm glad you found it helpful.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

 

[Bert Coules]

Suzanne,

Sorry to come back to you, but I hit a snag:

You were quite right, the utility is a macro (actually, it consists of two
macros) and I did find them listed as you described. But when I got to your
stage 3...

Select it and click the <<Copy button to copy it into your document...

....unfortunately, I don't have a Copy button. Is there any other way of
getting the utility into my new blank document? Incidentally, the listing
gives the location of the macros as "All active templates and documents" -
changing the listing to "Normal.dot" removes them from the list.

Thanks again,

Bert

 

[Suzanne S. Barnhill]

You skipped the step where you click Organizer.... (in the Macros dialog).
The <<Copy button is in the Organizer.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

 

[Bert Coules]

Suzanne,

You skipped the step where you click Organizer.... (in the Macros dialog).
The <<Copy button is in the Organizer.

Oh, what a fool. Sorry about that.

However, I do still have a problem. The macros are evidently not stored in
Normal.dot, and so don't show up when I enter the Organizer. They're listed
as being in "All active templates and documents". The drop-down box in
Organizer shows only Normal.dot.

I tried loading a document which works with the macros, but they're still
not listed in Organizer.

I suspect that I'm missing something very simple here - but what is it
likely to be?

Many thanks again for yor help.

Bert

 

[Graham Mayor]

The organizer has two windows - one by default shows the content of the
normal template - the other the active document.
If the macros are not in the normal template (and notice that the dialog
displays only the modules that contain the macros and not the individual
macros) then close the normal template from the organizer dialog and open
the template that contains them instead.
Maybe http://www.gmayor.com/installing_macro.htm will help.

If the macro was supplied in a template then simply copy that template from
the startup folder of your old PC to the startup folder of the new one. You
can find the default location of the startup folder by typing (or copying)
%appdata%\Microsoft\Word\STARTUP to the address bar of Windows Explorer or
your browser.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Bert Coules]

Graham,

Thanks for that; I'll try it.

...open the template that contains them instead.

The problem is, I'm not at all sure now just where the macros are, or how
they were originally supplied to me by the programmer. I'll have a dig
around and see what I can find.

I'll report back (probably with yet another cry for help - thanks to you and
Suzanne for your patience).

Bert

 

[Graham Mayor]

Assuming you know the name of the macro, Press Alt+F8. The dialog will list
the available macros in the template or templates selected. By default this
will show All templates and documents, Select the macro name. If the macro
is in the normal template or in a document opened in Word you will have the
opportunity to edit it. Otherwise it will be greyed out. By clicking the
arrow at the right, you can narrow the list down to locate the template
containing the required macro.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Bert Coules]

Ha! I've just noticed that "Number Utility" (the name of the two linked
macros) has appeared in the File-Edit-View... bar at the top of the screen.

I've no idea how that happened, but it's extremely handy!

Bert