VBA code to find FOLDER last modified date

[CescoL]

I am trying to write a Macro that lets me select a directory and will return the last time a folder has been modified, created, accessed, etc.

I'm not very familiar with VBA, but if someone could let me know if it's possible to write such a code and if they could provide me with instructions for how to insert the macro it would be much appreciated.

Thanks and Regards,
FL

[MartinLiss]

Moved thread to here.

[Siddharth Rout]

It would help if you tell us the application from which you want to try that.... like Excel, Word, Powerpoint etc... Also please mention the Office version that you are using...

[CescoL]

I apologize for the lack of information in my previous post.

Essentially, I would like to use Excel 2003 to run a Macro which provides me information regarding the folder activity on the shared drives of my network at work. We use Office XP.

For example, I would like to use Excel, hit Alt F8 and be able to run a macro that will prompt me to select a directory/folder. After that directory/folder has been selected I would ideally like it to return the date that all of the sub folders (within the folder I had selected) was created, last modified, etc. for all of the folders within the larger folder which i originally selected.

For example if I have a folder called "Company X" and within Company X are 3 folders: "Income Statement," "Balance Sheet," and "Cash Flow," I would like to be able to select the Company X folder and then have information regarding when the income statement, balance sheet, and cash flow statement folders were last modified.

Just wondering if something like that was possible. Thanks in advance for your help.