Hi Kenneth Hobs
I've got myself a simple way of coding which I prefer as it's easy to understand:-
HTML Code:
Code:
Sub Copy_Files()
Range("A1").Select
Range(Selection, Selection.End(xlDown)).Select
n = Selection.End(xlDown.Row
For i = 2 To n
FileCopy Source:=Cells(i, 1).Value & Cells(i, 2).Value, _
Destinatino:=Cells(i, 3).Value & Cells(i, 4).Value
Next i
MsgBox "File copy complete."
End Sub
But...when I want to empty (delete all files inside) the folders named in column C before I copy files from column B in forlders named column A. I tried using 'Kill' --> FileKill Source:=, Kill Source:=, Kill:=, Kill Path:=, etc...
HTML Code:
Code:
Kill Path:=Cells(i, 3).Value
...none of these seem like the correct name arguments.
Anyone could help?