I am using a Form created in MS Word and I am wanting to capture all the information input about the form and put it into a SQL Server Table using ActiveDocument. My Question is How would I kick off my macro in MS Word when the user does a Save or SaveAs because those are the events I need for my macro to run?
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!
MS Word to SQL Server Integration
- Thread starter mmcshane
- Start date
mmcshane,
I am trying to do the same thing, output word info to an SQL Server database. If you have found any info on this please let me know.
For your question: It has been a couple of years since I have programed in VB but If believe this is how it might work. In VB editor you create
Private Sub Document_Close()
End Sub
Under "this document". Then when the document closes the code in the Sub will be run.
I am trying to do the same thing, output word info to an SQL Server database. If you have found any info on this please let me know.
For your question: It has been a couple of years since I have programed in VB but If believe this is how it might work. In VB editor you create
Private Sub Document_Close()
End Sub
Under "this document". Then when the document closes the code in the Sub will be run.
- Status
Similar threads
- Locked
- Solved
- Locked
- Solved
- Locked
- Question
- Locked
- Helpful tip
