Hey GoingDeep;
I am doing something similar and haveing an irritating problem. I'm using;
Private Sub RunVisitsMerge_Click()
On Error GoTo Err_RunVisitsMerge_Click
Dim WordDocument As Word.Document
Set WordApp = CreateObject("Word.Application"
WordApp.Documents.Open ("S:\working\working Forms\Second Visit\By Date Range\CompleteMergeForFollowup.doc"
WordApp.Visible = True
Set WordApp = Nothing
Set WordDocument = Nothing
to open a Work Merge document. This document runs on a query that grabs start date and stop date from the form this VB is attached to. This is all across a network of course.
The problem is that I'll fill in the start and stop date on the form, and click the button that runs the VB above. Nothing. Wait about 30 seconds and click it again - a warning pops up that I already have the document open and that I can only open it in 'read only' mode. If I agree to that the merge document opens fine.
Any ideas at all?
"Man is the cheapest computer we can put into a spacecraft and the only one we can mass-produce with unskilled labor." Werner von Braun
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.