Move file from inside Access

A

ainow

Is there a command that can be ran from inside Access 07 (VBA) to move a file
from one folder to another?
 
S

Stuart McCall

ainow said:
Is there a command that can be ran from inside Access 07 (VBA) to move a
file
from one folder to another?
Click to expand...

Yes, if the folders are on the same drive, use the Name As statement:

Name "c:\test.txt" As "c:\MyFolder\test.txt"

If on different drives:

FileCopy "c:\test.txt", "d:\test.txt"
Kill "c:\test.txt"
 
Top