Moving files via VBA

[tim120harvey]

Hi,

I have a file (Doc1.csv) saved down at
C:\Documents\
and need to move it to
C:\Folder 1\

What is the script I need, to add this to my macro?
Many thanks for your help.

 

[Sektor]

Sub MoveFile()
    FileCopy Source:="C:\Documents\Doc1.csv", Destination:="C:\Folder 1\Doc1.csv"
    Kill "C:\Documents\Doc1.csv"
End Sub

Or:

Sub MoveFile2()
    CreateObject("Scripting.FileSystemObject").MoveFile "C:\Documents\Doc1.csv", "C:\Folder 1\Doc1.csv"
End Sub

 

[VoG]

Or

Sub a()
Name "C:\Documents\Doc1.csv" As "C:\Folder 1\Doc1.csv"
End Sub