loop through a list of links and download files.

Hi All,

I have the below function which helps me to download the files from a URL. Now I have a file where I have List of download links in column A and New File name in Column B and extension in Column C. I want to loop through the rows and download the files from the links present in column A and while saving the files use the new file name which is column b and extension present in column C.

Please Login or Register  to view this content.

I tried something like below but it's not working.

Please Login or Register  to view this content.

Please help..

Thanks a lot for your help in advance.

Hi JBeaucaire,

Thanks a lot for your reply, the code posted by you is not working. It gets stuck on the below code and shows a syntax error. Please help..

Please Login or Register  to view this content.

I have attached my macro file as well for your reference.

Thanks a lot for your help in advance.

Hi JBeaucaire,


Thanks a lot for your reply, now it's working fine. It downloads the files as far as your question is concerned it use to download the files earlier as well. The only thing is that as soon as I run the macro it shows some error popup message but once I click ok it starts downloading files. Even now I am facing the same issue. not sure how to fix the same.

Thanks a lot for your help.

Hi JBeaucaire,

Thanks a lot for your reply, But now it's showing a "Out of memory" error and when i debug it highlights the below code line. Not sure what is going wrong and what could be the reason everything looks fine.

Please Login or Register  to view this content.

Thanks a lot for your help in advance.