Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.newusers
Bert Coules[_2_] Bert Coules[_2_] is offline
external usenet poster
 
Posts: 4
Default Exporting a macro from one PC to another - advice appreciated

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


  #2   Report Post  
Posted to microsoft.public.word.newusers
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default Exporting a macro from one PC to another - advice appreciated

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" wrote in message
o.uk...
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



  #3   Report Post  
Posted to microsoft.public.word.newusers
Bert Coules[_2_] Bert Coules[_2_] is offline
external usenet poster
 
Posts: 4
Default Exporting a macro from one PC to another - advice appreciated

Brilliant, thanks, Suzanne.

Bert


  #4   Report Post  
Posted to microsoft.public.word.newusers
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default Exporting a macro from one PC to another - advice appreciated

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" wrote in message
o.uk...
Brilliant, thanks, Suzanne.

Bert



  #5   Report Post  
Posted to microsoft.public.word.newusers
Bert Coules[_2_] Bert Coules[_2_] is offline
external usenet poster
 
Posts: 4
Default Exporting a macro from one PC to another - advice appreciated

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




  #6   Report Post  
Posted to microsoft.public.word.newusers
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default Exporting a macro from one PC to another - advice appreciated

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" wrote in message
o.uk...
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



  #7   Report Post  
Posted to microsoft.public.word.newusers
Bert Coules[_2_] Bert Coules[_2_] is offline
external usenet poster
 
Posts: 4
Default Exporting a macro from one PC to another - advice appreciated

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


  #8   Report Post  
Posted to microsoft.public.word.newusers
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Exporting a macro from one PC to another - advice appreciated

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




"Bert Coules" wrote in message
o.uk...
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



  #9   Report Post  
Posted to microsoft.public.word.newusers
Bert Coules Bert Coules is offline
external usenet poster
 
Posts: 123
Default Exporting a macro from one PC to another - advice appreciated

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


  #10   Report Post  
Posted to microsoft.public.word.newusers
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Exporting a macro from one PC to another - advice appreciated

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



"Bert Coules" wrote in message
.. .
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





  #11   Report Post  
Posted to microsoft.public.word.newusers
Bert Coules Bert Coules is offline
external usenet poster
 
Posts: 123
Default Exporting a macro from one PC to another - advice appreciated

Graham,

It worked. I found the macro (actually two macros) in the Startup folder,
copied them across to the new machine - and there they were. I haven't yet
put them onto the Tools menu, but I've temporarily parked them on reassigned
(little-used) function keys, so they're instantly available.

I can't tell you how relieved I am! Many thanks to you and Suzanne.

Bert


  #12   Report Post  
Posted to microsoft.public.word.newusers
Bert Coules Bert Coules is offline
external usenet poster
 
Posts: 123
Default Exporting a macro from one PC to another - advice appreciated

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


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Another Find-and-Replace question. Help appreciated Bert Coules New Users 6 October 23rd 08 09:08 AM
Page Up/Down and cursor position - advice appreciated Bert Coules Page Layout 3 August 21st 07 10:44 PM
attn: magdalen - extremely appreciated dvd video - ozfu - (1/1) mill Page Layout 0 January 24th 07 08:18 PM
This ng much appreciated aalaan New Users 2 September 13th 06 01:05 PM
Tools/Options choice insists on thinking for itself - help appreciated Bert Coules New Users 7 September 12th 06 10:46 AM


All times are GMT +1. The time now is 05:19 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"