How to MOVE a text file after importing it?

[Atomic Shrimp]

I have an application which will import text files that appear in a folder on the server, I want it to import all of the files it finds (will be sequentially numbered file.001, file.002 etc) and then move them to another folder called '\done', I can work out everything except the actual moving of the files.

I know I could use FILECOPY and KILL, but my concern is that the multitasking aspects of VBA might cause the KILL operation to be started before the FILECOPY operation has finished, especially if the file is a large one. (incidentally, is this he kind of thing that can be overcome by inserting DoEvents in between the two operations?)

Is there a way of moving a file in a single operation? Actually, renaming the files would also be acceptable, if this is easier.

Thanks in advance

Mike

 

[Keith P]

Try: Name myFile As myNewFile

 

[Atomic Shrimp]

Thanks Keith

I can't believe I missed the Name Statement all this time.

(so actually I can rename AND move the files in the same operation)