Compile Error: User Defined Type Not Defined

[weigoldk]

I'm trying to run a "simple" merge into MS word from a button on a form.

I get the following Error at line 3

Compile Error:
User-defined type not defined

1 Private Sub cmdMergeWord_Click()
2 On Error GoTo Err_cmdMergeWord_Click
3 Dim objWord As Word.Application

I have the following References selected in Tools
"Visual Basic for Applications"
"Microsoft Access 11.0 Object Library"
"OLE Automation"
"Microsoft DAO 3.6 Object Library"
"Microsoft ActiveX Data Objects 2.1 Library"
"Microsoft Office 11.0 Office Libray"

 

[RoyVidar]

If you need to go early bound, you miss the reference to the Microsoft Word <version - 11?> Object Library

Roy-Vidar

 

[weigoldk]

I'm sorry--I should have also said I am very new to scripting.

I don't know if I need to go "early bound" or "late bound" or "on-time bound". I don't know what "bound" is or how I choose which way to go .

 

[RoyVidar]

If you add the reference, you'll be using early binding.

Roy-Vidar

 

[weigoldk]

Code:

Private Sub cmdPrtCCWWord_Click()
Call OpenWordDoc
End Sub


Public Function OpenWordDoc()
Dim objWord As Word.Application
End Function

 

[weigoldk]

Oops. I hit submit too quickly.

So, now I know I'm early binding.

How do I fix it--see my code above.

 

[PHV]

menu Tools -> References ...
tick the Microsoft Word 11.0 Object Library

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[weigoldk]

PHV,

Thanks for the reply. But like I said in the original post, I have the Microsoft Word 11.0 Object Library already included int he references.

 

[PHV]

But like I said in the original post, I have the Microsoft Word 11.0 Object Library already included int he references
Really ? Can you please reread carefully your own post ?

 

[weigoldk]

You caught me. The WORD library is not an option listed for me. I went out and checked the internet and found some evidence and feedback at other forums that the Office 11 library is a synonym for the Word 11 library.

I'm suspicious of that claim, but I haven't yet found a way to add in the Word library. Do you know how to add in that library?

 

[PHV]

I'm suspicious of that claim
Sure you should.

Do you have Word installed ?
If yes you may consider repair your msoffice install.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[weigoldk]

I have all of Office 2003 installed including Word. I'm getting the same error on at least two other computers both with Office 2003 installed.

I'll try a repair on my PC and let you know how it goes--I might not get to it today .