excel vba copy files

[Gabriel]

Hello,

I have a two columns : one with the path and one with the file name.
Can anyone show me how to create a macro that copy those files to
C:\Temp

So for each file (column B), it will use its path (column A) and makes
a copy of that file to C:\Temp until all the files have been copied.

Thank you in advance
Gabriel

 

[Ron de Bruin]

You can use FileCopy

You can loop through the list
If you need help post back

Sub A()
With Sheets("sheet1")
FileCopy .Range("A1").Value & .Range("B1").Value, "C:\" & .Range("B1").Value
End With
End Sub