nmkhan3010
New Member
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:
File name value range is from A2 to A50
Status range is from B2 to B50
Source path: "Shold be given manually" (Files need to copy from this location based on the excel value)
Destination path: "Shold be given manually" (Matched files based on the excel value need to copied in to this location)
Msg "Files Copied "
Besides list name colum can we insert update column as "copied" if it is found and "Doesn’t Exists" if it is not found.
File name value range is from A2 to A50
Status range is from B2 to B50
Format types: .doc, .rtf , .docx , .xlsx , .pdf
Please any one help me .....
Please find a attachment...
Thanks in advance.............
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:
File name value range is from A2 to A50
Status range is from B2 to B50
Source path: "Shold be given manually" (Files need to copy from this location based on the excel value)
Destination path: "Shold be given manually" (Matched files based on the excel value need to copied in to this location)
Msg "Files Copied "
Besides list name colum can we insert update column as "copied" if it is found and "Doesn’t Exists" if it is not found.
File name value range is from A2 to A50
Status range is from B2 to B50
Format types: .doc, .rtf , .docx , .xlsx , .pdf
Please any one help me .....
Please find a attachment...
Thanks in advance.............