Reading a Word doc file in Excel VBA

[phudgens]

I'm using Excel 2007 VBA to try and read a MS Word doc file by using the following code to convert it to RTF:

Dim WordApp
Set WordApp = CreateObject("Word.Application")
WordApp.Documents.Open FileName
WordApp.ActiveDocument.SaveAs DocFile, wdFormatRTF
WordApp.Quit

I'm getting a "Variable not defined" during compilation for "wdFormatRTF" - everything else is working. Does anyone know what causes that, or any way to read a doc file in to text strings line by line?

Thanks,
Paul Hudgens
Denver

 

[SkipVought]

In the VB Editor, Tools > References and CHECK the box for Microsoft Word m.n Object Library where m.n is the highest release.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[phudgens]

That worked. Thanks very much.