VBA to move an excel file to another folder

T

tvt

Hello,

I want to write a macro that takes an existing excel file (workbook) and
place it in another folder. Basically something that would simulate cutting
a file from one folder and pasting it in another. Is this possible using
VBA? If it is, what would be the code or where can i find the code to do so?
Thanks!
 
H

Harald Staff

Hi

It's very easy, given that the file and the to-folder already exist:

Sub MoveFile()
Name "C:\Temp\Book1.xls" As "C:\Junk\Book5.xls"
End Sub

HTH. Best wishes Harald
 
D

Dave Peterson

Look up Name in VBA's help.

Or even FileCopy and Kill.

These options will work if that file (doesn't have to be an excel workbook)
isn't open.
 
Top