vba to return the files and date last accessed in a directory

[timbo1957]

Hi,

Is it possible to run a macro that will list the files in a specific directory and give the date last accessed?

We are trying have a clear up of our main shared directory and something like this would be really useful.

There are folders that have limited access so that would have to be taken into account and there would be more files than the avilable number of rows in Office Pro 2003, so it would need to spill onto several tabs.

If this is possible does anyone have a macro that I could use?

Many thanks

[Chippy]

One way - probably the easiest and fastest - is with the DOS DIR command. Open a command window and enter something like:

DIR X:\Folder\Subfolder /S /OD /TA > dir.txt

followed by:

notepad dir.txt

[timbo1957]

Thanks Chippy.