Mass download hyperlinks

Hi, I am in search of vba macro with which I can download files from hyperlinks listed in B column and save each in respective new folder listed in column A. Any help will be appreciated. Thanks, Samadhan. PCosta87 Well-Known Member. Samadhan Gaikwad said:. End xlUp. Last edited: Jan 26, Hi, Thank you for providing such a nice code. It is working fine as expected.

But files that I am downloading are. Macro is creating folders to dump these files in respective folder but all are almost empty or in some cases there is File unwanted or may be log file created. Note that there is no direct path to file in hyperlink.

I have added in uploaded. Actually if go for manual download, user has to click button of that file and java script does download data.

Answer On the resource list tab, there is a directory input field. Here the user can set a download directory. Please note that every such directory is defined only relative to the default download directory this is a web extensions security limitation , so you can define only subdirectories of this main directory.

Another thing you can do is to use the general browser settings to change the location of this default download directory. Also, the user can prepare a custom favorite folders list see extension's options, the Download directories section. Once defined, this list will be available via autocomplete or simply by double-clicking this text field. Question 5. Why there are two add to queue buttons? Answer After checking some items from the resource list you can decide to send them either to the active queue, either to the passive queue using the corresponding buttons.

Sending to the active queue means that downloading starts immediately or as soon as possible. This is the best option if you are content with the default names or don't care too much about that.

On the other hand, sometimes it's better to rename queued items before starting downloading them. This can be done either individually using the edit button associated with every item from download list or in batch mode using the multi-rename dialog Question 6. I want to download some files from the resource list but I don't like the filenames used there.

On the original web page, they had other, better names. How to change that? But if the user clicks the name header of the resources table, he will be able to choose another attribute url, title, text, alt text for the actual displaying.

The most obvious candidate is the text attribute; that usually corresponds to what the user sees on the web page. Sending to the queue will preserve this displayed mask. But once the items are added to the queue not for immediate downloading , it's possible to rename them in more advanced ways. You can select some items and use the available multi-rename dialog for batch renaming them.

Here you can set a common name mask using many types of available masks, and combine them in various ways. Your extension is not capable to download embedded videos.

Answer My extension is, indeed, not designed to download embedded videos or streaming media but only normal, direct links. The main reason is that these extensions are most exposed to all sorts of legal issues and I don't want my extension to be taken down. Though, in the future, it's possible to add some more support for these types.

Question 8. Your extension is not capable to download files from sites X, Y, Z Answer My extension tries always to detect links that are included in the html source of the web pages.

But sometimes this doesn't work well. Many sites don't really like their resources to be mass downloaded because this way the users skip the associated ads. It is usually a time consuming and lengthy process to do it one by one and does take lots of patience. When you have selected all you want to Download, simply press the Download button and it starts to download all of them without any intervention from you.

Unlike many other extensions and tools which we have seen earlier like Bulk Image Downloader and BYTubeD , the Download Master is a much simpler tool to download all kind of downloadable files from any webpage and it it is very light on resources as well being so light weight.