Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Extracting MS Word File Data from Excel

Status
Not open for further replies.

nasar

IS-IT--Management
Aug 5, 2002
30
GB
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.
 
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")

Let me know if that helps!

VBAjedi [swords]
 
Thanks for that VBAjedi, it worked a treat.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top