Need Help With Opening a Word Document from Access
AND having Document_Open() activate automatically
AND having the file available for editing/saving.
I have tried the following, but the document opens as a READ-ONLY file and VBA is NOT enabled or prompted for.
I need the file to open for editing & saving, and with VBA enabled automatically.
Code:
Private Sub cmdTO_Click()
On Error Resume Next
Dim Webtarget As String
Dim wdObj As Object
Dim wdDoc As Object
'Must enable the Microsoft Word 14.0 Object Library from the Tools menu, References.
Webtarget = "\\...\ShiftTurnover\U1TO.docm"
Set wdObj = CreateObject("Word.Application")
wdObj.Visible = True
wdObj.Activate
Set wdDoc = wdObj.Documents.Open(Webtarget)
DoCmd.SetWarnings True
End Sub
Is there more to the .Documents.Open(___) syntax to allow opening for editing and macro enabling?
Your help is GREATLY appreciated.
