Move / rename a file

[hardy1976]

Hi,

I have a process of loading a file to a temporary table and then appending the relevant records to another table.

Is there a way I can use VBA to either rename the file or ideally move it to another folder?

Regards
H.

 

[Galaxiom]

VBA can drive Windows itself.

Check out the FileSystemObject.

 

[gemma-the-husky]

but simply

name oldfile newfile

will do the job.

 

[hardy1976]

Found a super way of doing this...

OldName = "C:\MYDIR\OLDFILE": NewName = "C:\YOURDIR\NEWFILE"
Name OldName As NewName ' Move and rename file.

http://www.access-programmers.co.uk/forums/showthread.php?t=67450