Extracting MS Word File Data from Excel

[nasar]

I have written a VBA module within Excel 97, which lists the files in a directory (mainly Word documents).

Now, Word 97 has some fields which store the Title, Subject, Author, Category etc.. information (which can be obtained by selecting File-Properties).

I would like to extract the data from those fields for each of the Word documents in the directory and display them with the filename in my worksheet.

Any ideas on how I can extract this information would be appreciated.

 

[VBAjedi]

Read the Microsoft Office Visual Basic help file entry on the "DocumentProperty Object". It lists possible properties and shows you how to access them. For example, to access the author for a Word.Document object named wdDoc you would use:

x = wdDoc.BuiltinDocumentProperties("Author&quot

Let me know if that helps!

VBAjedi

 

[nasar]

Thanks for that VBAjedi, it worked a treat.