Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exit Macro in Word

Status
Not open for further replies.

Elena

Technical User
Oct 20, 2000
112
US
I am trying to automatically fill-in a report in Word from Visual Basic. This form is protected and has exit macros attached to each form field. I know how to select and fill-in the fields from VB, but how do I make the exit macro run when I go to the next field? The exit macro takes the results from the form field and makes a summary table from the answers.

I tried .ActiveDocument.Bookmarks("Bookmark").Select and .Selection.GoToNext what:=wdGoToField, but neither will cause the exit macro to run. This form works if it is filled in manually, so I should be able to make it work from VB, right?

I would appreciate any tips.

Thanks,

Elena
 
Are you running the Macro on Word?
or
this macro is part of your VB app?
I have a lot of reports in this way and it didn't do nothing wrong
Can you send me a copy of your VB code?
rmadiedo@excite.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top