Extract Info From All Files in a Directory Q

[Sean]

Is it possible to extract the following details from All Excel files in
a particular folder (say C:\My Documents\Extract Folder)

1) Author
2) date of Creation
3) Date of extraction i.e. the time and date I run the code (usually
will run every day)

I was hoping to run a piece of code that would extract out the above in
a simple sheet, possibly without even opening the files with 1) above
listed in Column A and 2) above listed in Column B and 3) above in
column C. All files in this folder will be Excel


Thanks

 

[NickHK]

Sean,
MS have a component called DSOFile that you can use:
http://www.microsoft.com/technet/scriptcenter/resources/tales/sg0305.mspx

Some people report problems, but it has worked for me.

Not sure what you by #3. Sure you know what time you run the code.
Or is there some value in the WB that indicates this ?

NickHK

 

[Sean]

Thanks Nick, I'll have a go at that.

Was looking for 3 so I could archive some files (have quite a few) and
I'd have a reference date of what to archive.

 

[NickHK]

Sean,
Well, there's nothing built-in that indicates the "last time macros were
run".
However, there is the DateLastModified or you could create a custom property
to indicate that and read it with the DSOFile.

NickHK