Hello,
I don't really know where to start with something like this. I've got a spreadsheet that has a documents going down column C and the paths of these documents listed in column D. (example)
What I need VBA to do is go through all of the various paths down column D and save a copy of that document in a dump folder basically collating all of these documents into one place.
Is this possible using something like FSO.GetFolder? or would this be too much for VBA to handle here?
I don't really know where to start with something like this. I've got a spreadsheet that has a documents going down column C and the paths of these documents listed in column D. (example)
What I need VBA to do is go through all of the various paths down column D and save a copy of that document in a dump folder basically collating all of these documents into one place.
Is this possible using something like FSO.GetFolder? or would this be too much for VBA to handle here?