exporting file properties

P

Paul CSI Audit

Is there a way to automatically create a list in Access or Excel of file
properties? The files will all be Excel at first, and may be in different
directories. I would also like to choose which properties to view, since
there may be custom properties for the files as well.
 
G

Gord Dibben

Paul

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.

Then..........

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

http://support.microsoft.com/default.aspx?scid=KB;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.

Alternative........a User Defined Function in Excel.

Function DocProps(prop As String)
Application.Volatile
On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties _
(prop)
Exit Function
err_value:
DocProps = CVErr(xlErrValue)
End Function

'=DOCPROPS("last author")
'or
'=DOCPROPS("last save time")

Gord Dibben Excel MVP

On Wed, 27 Oct 2004 11:23:03 -0700, "Paul CSI Audit" <Paul CSI
 
Top