Hi,

I am attempting to automate MS Word from inside of my MS Access
program. Here is my code:

Private Sub cmdTest_Click()
Dim objWord As Word.Application
Dim objDoc As Word.Document

Set objWord = New Word.Application

objWord.Visible = True
End Sub

I am using early binding and at design time, everything is normal.
The code completion feature correctly completes Word.Application. It
compiles OK. But when I go to execution, it stops on the Set objWord = New
Word.Application line. The error message states: "Automation Error. The
specified module could not be found". In my References, I have the
following items checked:

Visual Basic for Applications
Microsoft Access 11.0 Object Library
OLE Automation
Microsoft DAO 3.6
Microsoft ActiveX Data Objects Library 2.8
Microsoft Office 11.0 Object Library
Microsoft Excel 11.0 Object Library
Microsoft Outlook 11.0 Object Library
Microsoft Word 11.0 Object Library

Can anyone tell me what I am doing wrong? Is there a reference that I have
left out that needs to be checked?


JD

Not sure about your Set ... New statement. I tend to use CreateObject when
I do automation like:

Set xlApp = CreateObject("Excel.Application")


--
HTH
Van T. Dinh
MVP (Access)



"Joe Delphi" <(E-Mail Removed)> wrote in message
news:BtfZg.3245$xI4.3034@fed1read11...
> Hi,
>
> I am attempting to automate MS Word from inside of my MS Access
> program. Here is my code:
>
> Private Sub cmdTest_Click()
> Dim objWord As Word.Application
> Dim objDoc As Word.Document
>
> Set objWord = New Word.Application
>
> objWord.Visible = True
> End Sub
>
> I am using early binding and at design time, everything is normal.
> The code completion feature correctly completes Word.Application. It
> compiles OK. But when I go to execution, it stops on the Set objWord =
> New Word.Application line. The error message states: "Automation
> Error. The specified module could not be found". In my References, I
> have the following items checked:
>
> Visual Basic for Applications
> Microsoft Access 11.0 Object Library
> OLE Automation
> Microsoft DAO 3.6
> Microsoft ActiveX Data Objects Library 2.8
> Microsoft Office 11.0 Object Library
> Microsoft Excel 11.0 Object Library
> Microsoft Outlook 11.0 Object Library
> Microsoft Word 11.0 Object Library
>
> Can anyone tell me what I am doing wrong? Is there a reference that I
> have left out that needs to be checked?
>
>
> JD
>
>