excel vba‎ > ‎

VBA - Copy and Move files and folders

posted Feb 4, 2011, 5:34 AM by Roberto Felicini
Sub Copy_One_File()
    FileCopy "C:\SourceFolder\Test.xls", "C:\DestFolder\Test.xls"
End Sub

Sub Move_Rename_One_File()
'You can change the path and file name
    Name "C:\SourceFolder\Test.xls" As "C:\DestFolder\TestNew.xls"
End Sub

Comments