Trouble opening Word document

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My overall problem involves extracting data from Word documents, and is
similar to other problems found in other Excel discussions. My specific
problem involves a problem I run into when trying the code from these
discussions.

I get errors with the dimmension statements, like:
Dim appWord As New Word.Application
or
Dim appWD As New Word.Application

I get the error:
Complie error: User-defined type not defined

Do I need a special add-in or something to open Word documents?
(I'm running Excel 2003.)
 
Richard,

At the top of the VBE Window, click 'Tools > References'. Set a reference
to the "Microsoft Word 11.0 Object Library". That should take care of the
problem.

Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA Programming: Word Document Compare? 0
Copying part of a header from active word document and pasting in excel using VBA 0
automatically number a table in word document 2
User Defined Type Not Defined 0
VB code to open other applications from templates 6
Opening A word Doc using VbA Word doc opens but minimizes 5
Copy from WORD to EXCEL using a macro..... 1
Closing Instance of Word 1

Back
Top