Raygan

I think what I needed most was how to proceed. I think with your input I should be able to write it myself with the help of some of my coworkers. All I need to do now is find some time.

Thanks!

I have files I have to archive every month. They are filed according to the date they were modified so they can be reactivated later.

I need help writing a macro to do this, that I can run once a month on files that are 30 days old.

Here's an example.

The files are located in L:\logos\scan\

Files with the modified date of august 1, 2007 need to be moved into the folder:

j:\07\08\01\

Files dated August 2, 2007 are moved to:

j:\07\08\02\

Thanks in advance.