Filename Properties

[MacroMan007]

I have a question and it's probably a long shot, but maybe someone will have a suggestion I can use.

What I am trying to do, is get the Modified & Creation Date of all files in a series of folders. For instance, the files can be .pdf, .xls, .doc, .rtf and would be located: in "This Folder" and possibly subfolders of "This Folder".

\\Folder\Subfolder\Company Name\This Folder\
or
\\Folder\Subfolder\Company Name\This Folder\Pending\

Is there a way to get a list, in Excel 2003, of the filenames meeting my criteria through VBA?

Thanks in advance for your help!

 

[texasalynn]

take a look at Chip Pearson's write up
http://www.cpearson.com/excel/docprop.aspx

 

[Greg Truby]

Sorry, doing a "drive by" or a "mouse by" as the case may be...

Search here for threads involving usage of the FileSystemObject.

Also, root around in this part of the MSDN website:

http://msdn.microsoft.com/en-us/library/1ft05taf(VS.85).aspx

EDIT - in Excel 2003, I think you could also use the FILESEARCH object. You might have a look at that too. Note that this was taken out of Excel 2007 (and many, many users screamed about).

 

[MacroMan007]

Thanks, I did see Chip Pearson's posting, but I wasn't sure how to use it. It did look somewhat helpful. I downloaded it and I'll take a look at it again tomorrow and see if I can figure out something to use there.

I appreciate your help.

 

[MacroMan007]

Greg,
Thanks for your reply and I tried some code that used "FileSystemObject", but I got some errors. I'll revisit them as well.

Thanks again for your help.