RE: Can I move files From Drive to drive using VBA

From: Jim Thomlinson (JimThomlinson_at_discussions.microsoft.com)
Date: 01/18/05 

Date: Tue, 18 Jan 2005 11:31:06 -0800

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 spread***. 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.