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.
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.