Dennis

Not too automatic, but......

You could stick all workbooks into one Folder.

Open Windows Explorer.

Right-click on any column header and add a check to each of the columns of
information you wish to show(author, owner etc.).

Then..........

To add a "Print Directory" feature to Explorer, go to
this KB Article.

http://support.microsoft.com/default...EN-US;q272623&

Or you can download Printfolder 1.2 from.....

http://no-nonsense-software.com/freeware/

I use PF 1.2 and find it to be more than adequate with custom features.

OR Go to DOS(Command) prompt and directory.
Type DIR MYFILES.TXT

All the above create a *.TXT file which can be opened in Excel.

Gord Dibben Excel MVP

On 1 Nov 2004 07:46:23 -0800, (Dennis Hancy) wrote:

I need to produce a listing of files along with date created, date
modified, owner, and author. I am using the file properties
dateCreated and dateLastmodified for the first two.

Are there similar properties to get the owner and the author?

If not, how else can I get this information?

Thanks.


Dennis Hancy
Eaton Corporation
Cleveland, OH