I have the following attached Excel 2010 worksheet which has two columns called Links1 and Links2. I would like a two macros created. One for each of the Links columns.
I'd like each macro to loop through the rows and download each file, saving them to a c:\temp directory.
The spreadsheet already has some vba code in module1. I wish to leave all existing code as is. I'd like your macro code to simply be added to mine with helpful comments.
Here's a recap of the requirements:
1. Create a macro that I can run on the Links1 column which will loop through and download the files to a c:\temp directory.
2. Create a macro that I can run on the Links2 column which will loop through and download the files to a c:\temp directory.
3. Add helpful comments to your macros explaining what's going on.
## Deliverables
My current spreadsheet is attached in the zip file.