Retrieve Word properties into Excel? 1

[MicroZealous]

Good Evening;
I have about 250 Word documents, and have created an Excel sheet as an index. One row per Word doc, with a hyperlink to the actual document. Now: How can I retrieve Word doc Properties (Title, Subject, Keywords, number of pages, last saved date etc) into cells in the spreadsheet?

(Using Word/Excel 2002)

TIA

 

[PHV]

Have a look here:

http://www.microsoft.com/technet/scriptcenter/resources/tales/sg0305.mspx

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886