VBA - Copy and Move files and folders

Post date: Feb 4, 2011 1:34:59 PM

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