View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
shishi shishi is offline
external usenet poster
 
Posts: 33
Default TYPE Library issues.

Hi ,

I have started on a project to generate ms-word documents from excel
sheet. The vba code starts something like below.

Dim oWrd As Word.Application
Dim oDoc As Word.Document
Set oWrd = New Word.Application

I am getting an error from the first line. The error is "complie error:
User-Defined type not defined". I checked Tools-References and found
that the following are already checked.
1. Visual Basic for applications
2. Microsoft Excel 9.0 Object Library
3. OLE Automation
4. Microsoft Office 9.0 Object Library
etc.

What could be that I am doing wrong? Please help. Thanks in advance
for your suggestion.

shishi