VBA Code to copy files from form one folder to another based on paths and file names list in excel

[Harish Kumar Manohar]

Dear All,

I am looking for a VBA code to copy a huge number of files from one location to another based on location based on the path listed in different columns.
Also Copied files needs to be renamed as listed and need comments on the copy status.

Here is the excel template looks like:

Source File Name	Source Path	New File Name	Destination Path	Status
Tracker.xlsx	C:\Users\harish\Desktop\From	New_Tracker.xlsx	C:\Users\harish\Desktop\To	Copied
5369 Summary.xlsx	C:\Users\harish\Desktop\From\Sum	New_5369 Summary.xlsx	C:\Users\harish\Desktop\To\Sum	Copied
5369 Diff .docx	C:\Users\harish\Desktop\From\Diff	New_5369 Diff .docx	C:\Users\harish\Desktop\To\Diff	Copied
Signed.pdf	C:\Users\harish\Desktop\From	New_Signed.pdf	C:\Users\harish\Desktop\To	Not copied
Signed2.pdf	C:\Users\harish\Desktop\From\Signed	New_Signed2.pdf	C:\Users\harish\Desktop\To\Signed	Not copied
Test Reports.pdf	C:\Users\harish\Desktop\From\Report	New_Test Reports.pdf	C:\Users\harish\Desktop\To\Report	Copied
Master.docx	C:\Users\harish\Desktop\From\Tracker	New_Master.docx	C:\Users\harish\Desktop\To\Tracker	Copied

Please need your support.

Regards,
Harish

 

[Harish Kumar Manohar]

Dear All,

I am looking for a VBA code to copy a huge number of files from one location to another based on location based on the path listed in different columns.
Also Copied files needs to be renamed as listed and need comments on the copy status.

Here is the excel template looks like:

Source File Name	Source Path	New File Name	Destination Path	Status
Tracker.xlsx	C:\Users\harish\Desktop\From	New_Tracker.xlsx	C:\Users\harish\Desktop\To	Copied
5369 Summary.xlsx	C:\Users\harish\Desktop\From\Sum	New_5369 Summary.xlsx	C:\Users\harish\Desktop\To\Sum	Copied
5369 Diff .docx	C:\Users\harish\Desktop\From\Diff	New_5369 Diff .docx	C:\Users\harish\Desktop\To\Diff	Copied
Signed.pdf	C:\Users\harish\Desktop\From	New_Signed.pdf	C:\Users\harish\Desktop\To	Not copied
Signed2.pdf	C:\Users\harish\Desktop\From\Signed	New_Signed2.pdf	C:\Users\harish\Desktop\To\Signed	Not copied
Test Reports.pdf	C:\Users\harish\Desktop\From\Report	New_Test Reports.pdf	C:\Users\harish\Desktop\To\Report	Copied
Master.docx	C:\Users\harish\Desktop\From\Tracker	New_Master.docx	C:\Users\harish\Desktop\To\Tracker	Copied

Please need your support.

Regards,
Harish

Sorry missed to mention, Folder & Sub folder to be created and copy the files to the destination.