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
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