Copy files from a source to destination by reading Path from Excel.

[fareed]

Dear All,

I would like to copy files from a source to destination by using Excel Macro/Batch file.
I have saved the path of the files of source and destination as columns in Excel sheet.
I would like to know how to write VBA macro to copy files by reading the source/destination path from columns.

Thanks in advance.
Regards,

Fareed.

 

[wigi]

Hello

Welcome to MrExcel.

If column A has the source files (path and filename and extension), and column B as the target files (path and filename and extension), then this will work:

For Each r In Columns(1).SpecialCells(2,2)
   If Len(Dir(Trim(r.Value))) Then FileCopy r.Value, r.Offset(,1).Value
Next

 

[fareed]

Hello

Welcome to MrExcel.

If column A has the source files (path and filename and extension), and column B as the target files (path and filename and extension), then this will work:

For Each r In Columns(1).SpecialCells(2,2)
   If Len(Dir(Trim(r.Value))) Then FileCopy r.Value, r.Offset(,1).Value
Next

Thanks for the prompt response. I will try it out once I am at the console.

Just to clarify : Column A has Source path only ( The actual folder has multiple files and all of them need to be copied).
Column B has destination path ONLY.

Will the above solution work in such a scenario ?


Thanks once again.
Fareed

 

[wigi]

Thanks for the prompt response. I will try it out once I am at the console.

Just to clarify : Column A has Source path only ( The actual folder has multiple files and all of them need to be copied).
Column B has destination path ONLY.

Will the above solution work in such a scenario ?


Thanks once again.
Fareed

No. You will need to use the Dir( ) function to loop through the files in the directory in column A.