Here is a simple code that moves all the files from one folder to another using XCOPY. You can use all the options of XCOPY with VBA
Sub Copy_Bunch_Of_Files() Shell "cmd /c xcopy /y c:\temp\*.* C:\Temp\Backup" End Sub
Explore comprehensive and specialized Course on Excel Automation or VB Programming here and, learn to write complex VB Coding with ease.