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 / January 2005

Tip: Looking for answers? Try searching our database.

Running a Macro in a Template, on Event

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
David - 07 Jan 2005 00:05 GMT
Hi.

I have a macro that I've constructed in word which will insert bookmarks as
per a table template that I've created in our Visual FoxPro based
database/frontend.  The Visual FoxPro frontend inserts this information into
Word - and I've also instructed it to use a word template which contains my
Macro

The Macro works fine, but what I'm wanting to do is automate the process,
rather than having to run the Macro once the document has been produced from
FoxPro, using the .dot file.

Is there any way to make this happen? I've tried several of the On-Events
but none of them seem to work. What I basically want it to do, is once the
Document has been opened and the information has been sent to it from our
FoxPro database, that the Macro automatically runs

Thanks in Advance
David Bloch
Houston Medical
Tom Winter - 07 Jan 2005 15:13 GMT
You may want to look in to Auto macros. Here's a couple of quick sources:

WD2000: Auto Macros in Word
http://support.microsoft.com/?kbid=211659

Running a macro automatically when a document is created, opened or closed
http://word.mvps.org/FAQs/MacrosVBA/DocumentEvents.htm

How to create global event procedures similar to AutoOpen, AutoNew and
AutoClose, without using Normal.dot
http://word.mvps.org/FAQs/MacrosVBA/PseudoAutoMacros.htm

Signature

Tom Winter
Tom@NoSpam.AmosFiveSix.com

> Hi.
>
[quoted text clipped - 16 lines]
> David Bloch
> Houston Medical
 
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.