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
"tvt" skrev i melding
...
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!
|