Group:  Microsoft Word ยป microsoft.public.word.vba.beginners
Thread: deploying Word macro

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Rising Antivirus 2006

deploying Word macro
"KR" <not_a_real_address[ at ]spamfilter.com.net.org> 16.08.2006 13:57:20
I have a Word macro that I use, and some other folks have expressed an
interest in using it as well (non-local, non-networked users some of whom
have very little technical skill- we all volunteer for the same national
organization). I've reviewed the FAQ and searched google, but while I'm sure
the information is out there somewhere, I haven't found it (at least not
phrased in a dumbed-down way so I can understand it).

When I use the macro it is inside my target document, so it is easy to find
and use. The new potential users are not all savvy to the world of Word and
macros, so I want to make it as easy as possible for them to run this macro.
Ideally, I'd send them a word file that they could just click and open, and
then go back to their own document and run the macro (where the macro
resides in the file I send, but acts on 'activedocument'). In Excel this is
easy because all macros are shown in the macro list, and you can select
macros from other open workbooks. I have (so far) been unable to replicate
this in Word- even when I select to show "All active templates and
documents" on the macro run dialog box, I don't see the macros I have in
other open Word documents at the time.

Is there something I need to do in the workbook containing the code to make
those macros visible in the macro dialog box?

Many thanks,
Keith
--
The enclosed questions or comments are entirely mine and don't represent the
thoughts, views, or policy of my employer. Any errors or omissions are my
own.


Re: deploying Word macro
"Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> 16.08.2006 14:14:37
Save the macro in a blank document and save that document as a template.
Supply the template to your users and tell your users to copy the template
into the Word startup folder (defined at tools > uptions > file locations >
startup)
See http://www.gmayor.com/Template_Locations.htm and
http://www.gmayor.com/installing_macro.htm

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

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

KR wrote:
[Quoted Text]
> I have a Word macro that I use, and some other folks have expressed an
> interest in using it as well (non-local, non-networked users some of
> whom have very little technical skill- we all volunteer for the same
> national organization). I've reviewed the FAQ and searched google,
> but while I'm sure the information is out there somewhere, I haven't
> found it (at least not phrased in a dumbed-down way so I can
> understand it).
>
> When I use the macro it is inside my target document, so it is easy
> to find and use. The new potential users are not all savvy to the
> world of Word and macros, so I want to make it as easy as possible
> for them to run this macro. Ideally, I'd send them a word file that
> they could just click and open, and then go back to their own
> document and run the macro (where the macro resides in the file I
> send, but acts on 'activedocument'). In Excel this is easy because
> all macros are shown in the macro list, and you can select macros
> from other open workbooks. I have (so far) been unable to replicate
> this in Word- even when I select to show "All active templates and
> documents" on the macro run dialog box, I don't see the macros I have
> in other open Word documents at the time.
>
> Is there something I need to do in the workbook containing the code
> to make those macros visible in the macro dialog box?
>
> Many thanks,
> Keith


Re: deploying Word macro
"KR" <not_a_real_address[ at ]spamfilter.com.net.org> 16.08.2006 14:34:09
Thank you Graham, I'll give it a try. I was hoping for a solution that
didn't require the more novice (e.g. Word = Notepad) users to have to
interact with too many menu options or have to figure out things like
template directories ...but I guess the ones that are more PC-smart will be
able to figure it out and use the macro, and the rest will just have to do
without...

Thanks again,
Keith

"Graham Mayor" <gmayor[ at ]REMOVETHISmvps.org> wrote in message
news:Od2RJ5TwGHA.1272[ at ]TK2MSFTNGP05.phx.gbl...
[Quoted Text]
> Save the macro in a blank document and save that document as a template.
> Supply the template to your users and tell your users to copy the template
> into the Word startup folder (defined at tools > uptions > file locations
>
> startup)
> See http://www.gmayor.com/Template_Locations.htm and
> http://www.gmayor.com/installing_macro.htm
>
> --
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> Graham Mayor - Word MVP
>
> My web site www.gmayor.com
> Word MVP web site http://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>
> KR wrote:
> > I have a Word macro that I use, and some other folks have expressed an
> > interest in using it as well (non-local, non-networked users some of
> > whom have very little technical skill- we all volunteer for the same
> > national organization). I've reviewed the FAQ and searched google,
> > but while I'm sure the information is out there somewhere, I haven't
> > found it (at least not phrased in a dumbed-down way so I can
> > understand it).
> >
> > When I use the macro it is inside my target document, so it is easy
> > to find and use. The new potential users are not all savvy to the
> > world of Word and macros, so I want to make it as easy as possible
> > for them to run this macro. Ideally, I'd send them a word file that
> > they could just click and open, and then go back to their own
> > document and run the macro (where the macro resides in the file I
> > send, but acts on 'activedocument'). In Excel this is easy because
> > all macros are shown in the macro list, and you can select macros
> > from other open workbooks. I have (so far) been unable to replicate
> > this in Word- even when I select to show "All active templates and
> > documents" on the macro run dialog box, I don't see the macros I have
> > in other open Word documents at the time.
> >
> > Is there something I need to do in the workbook containing the code
> > to make those macros visible in the macro dialog box?
> >
> > Many thanks,
> > Keith
>
>


Re: deploying Word macro
"Charles Kenyon" <wordfaq[ at ]nospam.addbalance.com> 16.08.2006 14:47:37
See http://addbalance.com/word/movetotemplate.htm for step-by-step
instructions on moving / sharing / copying / backing-up customizations
including AutoText, AutoCorrect, keyboard assignments, toolbars, macros,
etc.
--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!

My criminal defense site: http://addbalance.com
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"KR" <not_a_real_address[ at ]spamfilter.com.net.org> wrote in message
news:O8%23blvTwGHA.4972[ at ]TK2MSFTNGP05.phx.gbl...
[Quoted Text]
>I have a Word macro that I use, and some other folks have expressed an
> interest in using it as well (non-local, non-networked users some of whom
> have very little technical skill- we all volunteer for the same national
> organization). I've reviewed the FAQ and searched google, but while I'm
> sure
> the information is out there somewhere, I haven't found it (at least not
> phrased in a dumbed-down way so I can understand it).
>
> When I use the macro it is inside my target document, so it is easy to
> find
> and use. The new potential users are not all savvy to the world of Word
> and
> macros, so I want to make it as easy as possible for them to run this
> macro.
> Ideally, I'd send them a word file that they could just click and open,
> and
> then go back to their own document and run the macro (where the macro
> resides in the file I send, but acts on 'activedocument'). In Excel this
> is
> easy because all macros are shown in the macro list, and you can select
> macros from other open workbooks. I have (so far) been unable to replicate
> this in Word- even when I select to show "All active templates and
> documents" on the macro run dialog box, I don't see the macros I have in
> other open Word documents at the time.
>
> Is there something I need to do in the workbook containing the code to
> make
> those macros visible in the macro dialog box?
>
> Many thanks,
> Keith
> --
> The enclosed questions or comments are entirely mine and don't represent
> the
> thoughts, views, or policy of my employer. Any errors or omissions are my
> own.
>
>


Home | Search | Terms | Imprint | Contact
Newsgroups Reader - provided by WiredBox.Net