If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

BROWSE, SEARCH AND COPY FILES FROM ONE LOCATION TO ANOTHER BASED ON THE LIST GIVEN IN EXCEL SHEET BY VBA

Thread starter nmkhan3010
Start date Apr 4, 2020

nmkhan3010

New Member

Apr 4, 2020

Hi,

I need a macro for BROWSE, SEARCH AND COPY FILES FROM ONE LOCATION TO ANOTHER BASED ON THE LIST GIVEN IN EXCEL SHEET USING VBA.

Range is selected in excel

Source path: "Shold be given manually"
Destination path: "Shold be given manually"

Msg "Files Copied "

Besides list name colum can we update "copied" if it found and "N/A" if it is not found.

Format types: .doc, .rtf , .docx , .xlsx , .pdf

Please any one help me .....

Thanks in advance.............

Also posted here BROWSE, SEARCH AND COPY FILES FROM ONE LOCATION TO ANOTHER BASED ON THE LIST GIVEN IN EXCEL SHEET USING VBA. - OzGrid Free Excel/VBA Help Forum

Last edited by a moderator: Apr 4, 2020