Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / August 2007

Tip: Looking for answers? Try searching our database.

A Macro that calls another macro?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Trefilov22 - 20 Aug 2007 14:50 GMT
Here's what I need to do.  I need to create a macro that opens a list that
the user can choose a specific person from.  A little background, I have
signature blocks for nine people set as autotext.  I need to create a macro
that brings up a list of those nine people, that a user can choose one from.  
Once the user chooses that person, it drops in the signature block for that
particular person from their autotext entry. Is this possible?  And if so,
can someone steer me in the right direction?
Jay Freedman - 20 Aug 2007 14:59 GMT
Probably you can do without a macro at all. Have a look at
http://www.word.mvps.org/FAQs/TblsFldsFms/AutoTextList.htm.

Signature

Regards,
Jay Freedman
Microsoft Word MVP        FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

> Here's what I need to do.  I need to create a macro that opens a list
> that the user can choose a specific person from.  A little
[quoted text clipped - 4 lines]
> autotext entry. Is this possible?  And if so, can someone steer me in
> the right direction?
Trefilov22 - 20 Aug 2007 15:14 GMT
That looks alright, but it looks like it requires a specific word as a
trigger, which I don't want to have to do.  If there is a way to right click
and it pops up that list, that would be fine, but I don't want them to have
to type something, just to right click it, and choose the proper name.

> Probably you can do without a macro at all. Have a look at
> http://www.word.mvps.org/FAQs/TblsFldsFms/AutoTextList.htm.
[quoted text clipped - 7 lines]
> > autotext entry. Is this possible?  And if so, can someone steer me in
> > the right direction?
Jay Freedman - 20 Aug 2007 16:34 GMT
Read it again... there's nothing like a "trigger" in there, and no typing is
necessary for the end user. You create the field, they just click it and
select a name from the dropdown.

Signature

Regards,
Jay Freedman
Microsoft Word MVP        FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

> That looks alright, but it looks like it requires a specific word as a
> trigger, which I don't want to have to do.  If there is a way to
[quoted text clipped - 20 lines]
>>> their autotext entry. Is this possible?  And if so, can someone
>>> steer me in the right direction?
Trefilov22 - 20 Aug 2007 16:42 GMT
Does this work even if the field isn't in a set location?  For example, they
are working on a document and its a page and a half, how will it know where
the field is?  Sorry I am semi-new to this stuff, and actually this would
probably be the most advanced that I have done.  I appreciate your help Jay!  
Let me know what you mean by "field"

> Read it again... there's nothing like a "trigger" in there, and no typing is
> necessary for the end user. You create the field, they just click it and
[quoted text clipped - 24 lines]
> >>> their autotext entry. Is this possible?  And if so, can someone
> >>> steer me in the right direction?
Jay Freedman - 20 Aug 2007 17:51 GMT
I apologize. I just went back and read through the article completely --  
something I haven't done for some time. You're correct in your reading, but
there's a simple adjustment.

In the numbered list of instructions under the heading "Create a pop-up list
of products", eliminate steps 12 and 13. Also eliminate the entire part
under the heading "Insert a product list in your document". Instead, when
you have completed step 11, you'll already have an AutoTextList field in the
document (the field you inserted in steps 9 through 11). Using cut (or copy)
and paste, you can position that field anywhere in the document, and you can
have more than one of them if needed. Save the document at that stage, and
distribute it to users.

For your signature application, instead of making the default text something
like "product" or "signature", I'd make it something like "Right-click here
to insert signature". Otherwise, it's difficult to distinguish the
AutoTextList default text from any other text until it's already clicked.

Signature

Regards,
Jay Freedman
Microsoft Word MVP        FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

> Does this work even if the field isn't in a set location?  For
> example, they are working on a document and its a page and a half,
[quoted text clipped - 38 lines]
>>>>> particular person from their autotext entry. Is this possible?
>>>>> And if so, can someone steer me in the right direction?
Trefilov22 - 20 Aug 2007 18:06 GMT
I still don't know if thats going to work as these documents are created
continuously. They don't use a set template for this sort of thing.  Some guy
is in my office right now cutting tile, so I am losing my mind.  I will take
a look at this more when I can actually think.  Thanks for the quick response
though Jay, I appreciate it!

> I apologize. I just went back and read through the article completely --  
> something I haven't done for some time. You're correct in your reading, but
[quoted text clipped - 56 lines]
> >>>>> particular person from their autotext entry. Is this possible?
> >>>>> And if so, can someone steer me in the right direction?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.