File Object in Excel VBA
 

Hi all. I'm trying to write a macro that writes the information stored in the
File Object for all the files in a directory into an excel sheet. I can
figure out how to do everything except get the Title, Author and Owner
properties. This information is available from windows explorer in Windows
2000 and XP, but I can't seem to access it from Excel VBA. Any Ideas?
Thanks.

File Object in Excel VBA
 

Hi Daylate$short,

See Chip Pearsons document properties page at:

http://www.cpearson.com/excel/docprop.htm

---
Regards,
Norman



"daylate$short" wrote in message
...
Hi all. I'm trying to write a macro that writes the information stored in
the
File Object for all the files in a directory into an excel sheet. I can
figure out how to do everything except get the Title, Author and Owner
properties. This information is available from windows explorer in
Windows
2000 and XP, but I can't seem to access it from Excel VBA. Any Ideas?
Thanks.