I would like to move and rename files automatically whenever someone finishes
with the spreadsheet. The idea is that they can only run it once and the data
files are moved until the next month, and ready for the next department to
use them.

Sure you can but be careful because inevitably someone will mess things up
and indicate that they are finised when they are not. You will want to
validate completeness before you move the files. Even then files are going to
be moved prematurely (you can always trust end users to foul up the
infallible). That having been said look up "file system objects" as that is
probably what you are looking for based on your question. The microsoft site
is a pretty good reference on this topic.

HTH

"Jeff" wrote:

I would like to move and rename files automatically whenever someone finishes
with the spreadsheet. The idea is that they can only run it once and the data
files are moved until the next month, and ready for the next department to
use them.

Take a look at Name in VBA's help.

Also FileCopy and Kill may be useful one day.

Jeff wrote:

I would like to move and rename files automatically whenever someone finishes
with the spreadsheet. The idea is that they can only run it once and the data
files are moved until the next month, and ready for the next department to
use them.

--

Dave Peterson