Opening Word Document using VBA in Access 2013

2019-08-02 03:28发布

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"

2条回答
太酷不给撩
2楼-- · 2019-08-02 03:48

Wouldn't be easier just to do:

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

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

查看更多
女痞
3楼-- · 2019-08-02 03:56

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.
查看更多
登录 后发表回答