BadgerRoad
Active Member
- Joined
- Dec 2, 2005
- Messages
- 301
- Office Version
- 365
- Platform
- Windows
I am trying to open a Word document with vba. Word will open but I'm getting an error on the Documents.Open line that says "Object Required". I've tried doing this many different ways but I keep getting the same error.
Any suggestions would be appreciated.
Any suggestions would be appreciated.
VBA Code:
Sub CreateWordApp()
Dim WordApp As Word.Application
Set WordApp = New Word.Application
WordApp.Visible = True
WordApp.Activate
'WordApp.Documents.Open ThisWorkbook.Path & "/" & "Mail merge list-online labels 875.docx"
WordDoc.Documents.Open "H:\Mail merge list-online labels 875.docx"
End Sub