Retrieve Word properties into Excel? 1

[MicroZealous]

Hi Kids! (Using Word/Excel 2002)
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 the Word doc Properties (Title, Subject, Keywords, number of pages, last saved date etc) into cells in the spreadsheet? TIA

 

[AnotherHiggins]

'Pretty sure you'll need to use VBA. Either a macro that you update periodically or a UDF.

I'm no good with WORD, but in excel you can refer to BuiltinDocumentProperties to get at all kinds of good file info.

For more detail, please repost in forum707.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[MakeItSo]

Higgins is right.
I've just let this little code snippet run

For i = 1 To 28
    Print #a, i & "  -  " & ActiveDocument.BuiltInDocumentProperties(i).Name
Next i

and this is the ouput:

1 - Title
2 - Subject
3 - Author
4 - Keywords
5 - Comments
6 - Template
7 - Last author
8 - Revision number
9 - Application name
10 - Last print date
11 - Creation date
12 - Last save time
13 - Total editing time
14 - Number of pages
15 - Number of words
16 - Number of characters
17 - Security
18 - Category
19 - Format
20 - Manager
21 - Company
22 - Number of bytes
23 - Number of lines
24 - Number of paragraphs
25 - Number of slides
26 - Number of notes
27 - Number of hidden Slides
28 - Number of multimedia clips

Just use Document.BuiltInDocumentProperties(i), with i being the index of the desired info (see list), et voilà!
;-)

Cheers,
Andy

[blue]Help us, join us, participate
IAHRA - International Alliance of Human Rights Advocates[/blue]

 

[fumei]

Or use Dsofile. See this same thread in the VBA forum.

Gerry
My paintings and sculpture

 

[MakeItSo]

That's a nice one, Gerry!
Downloaded that dso right away...


[blue]Help us, join us, participate
IAHRA - International Alliance of Human Rights Advocates[/blue]