Hi,
I have a list of files in my spreadsheet (column B) with their paths, ie. C:\Temp\test1.txt, C:\Temp\test2.txt and I want to copy them into a destination folder specific to each file (folders are already created) and paths are in column C. Ie. C:\Temp\folder1, C:\Temp\folder2
Is there an easy way to do this in VBA. All I can find is code to copy multiple files in one folder to another specific folder.
Thanks.
Possibly...
Sub CopyFiles() 'Assumes files are not open Dim rCell As Range For Each rCell In Range("B1:B" & Cells(Rows.Count, "B").End(xlUp).Row) Filecopy (source:=rcell, destination:=rcell.offset(0,1)) End Sub
Last edited by dangelor; 01-31-2017 at 01:51 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks