CODEWITHSUNDEEP
ms-accessms-wordvba
user2521720
user2521720

Reputation: 59

Opening Word Document using VBA in Access 2013

I'm using Access 2013 and created a help button on a form that I would like to open up a Word doc with instructions. Here's the code I tried:

Private Sub cmdHelp_Click()
    Dim wrdApp As Word.Application
    Dim wrdDoc As Word.Document
    Dim filepath As String

    Set wrdApp = CreateObject("Word.Application")
    wrdApp.Visible = True

    filepath = "C:\...\Handout.docx"
    Set wrdDoc = wrdApp.Documents.Open(filepath)
End Sub

The problem is, when I try to compile I get an error on the first line that says "User-defined type not defined"

Upvotes: 2

Views: 39183

Answers (2)

Kazimierz Jawor
Kazimierz Jawor

Reputation: 19067

Please check if you set appropriate reference to Word Library in VBA Environment.

To do so follow the path:

Go to VBA Editor >> Menu >> Tools >> References >> 
    Find on the list Microsoft Word XX.X Object Library where 
    XX.X is the highest available number >> 
Check it >> press OK.

Upvotes: 4

Fabio Pereira
Fabio Pereira

Reputation: 348

Wouldn't be easier just to do:

Shell "winword ""c:\...\Handout.docx"""

... instead of creating an object just to open the application?

Upvotes: 4

Related Questions