Creating a Loop for Macro

[glide2131]

So I found this code which loops through and opens up a url for every address that is listed in Column C (starting with row 8 and then saves it according to the folder location that is listed in cell B4. Each file is named according to the name which is in the column right next to it. So for example if I have 3 url addresses listed in rows 8,9, and 10 then I will end up with 3 saved web pages all saved in the folder identified in cell B4.

So what I am trying to do is to give each URL a different file location to be saved to. So instead of saving all pages to the same folder it will be saved to individual folders. I would like to use Column B as the location for the folder addresses.

Does anyone know how to help with this?

Please Login or Register  to view this content.

[mikeTRON]

You need to include the defining of the variable PDFFolder in the loop as follows

Please Login or Register  to view this content.