Built in Properties in Excel Docs

[Tiglet]

Hi,

I am trying to extract a full list of all Excel Spreadsheets on a drive showing their path and various document properties. I have found this excellent example on the web

http://www.exceltip.com/show_tip/Fi...Runtime_using_VBA_in_Microsoft_Excel/446.html

which works almost perfectly. However, I want to include in the properties that it lists out, the author's name and I can't work out how to do it. Any suggestions would be gratefully received. I have scoured the net to see if I can find something but to no avail.

Many Thanks

Tiglet

Living on Earth is expensive, but it does include a free trip around the sun every year

 

[xlhelp]

......... = Activeworkbook.Author

http://www.geniusmedia.ca

 

[Tiglet]

xlhelp,

Sorry, I actually posted this initially in the wrong forum - I've now posted it in the VBA forum and there is a thread ongoing there. The ActiveWorkbook approach doesn't seem to work as I'm not actually opening the files with the main code. If you would like to have a look at the thread in the VBA forum, I'd be very grateful for any assistance

Thanks

Tiglet

Living on Earth is expensive, but it does include a free trip around the sun every year