Download files from URL

Pegaso

New Member
Joined
Jun 25, 2012
Messages
21
<article>
Hello All,

I have a list of URLs that each one opens a webpage were an undetermined number of files (.pdf) are stored, I cannot anticipate the names of the files. I need a macro to go through each of those pages and automatically download all the files present there, save them in a local folder.

I had found solutions when the name of the file is known, but this is not my case, I hope somebody can help.

Warmest regards!:confused:

Pegaso​
</article>


 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Usually u can look at the HTML source code and search for the <href> tag that contains url which unique for downloading purposes.
If not, try to search the url one by one (which is like Internet Download Manager's coding), validate if it the url wont give the download dialog, skip.
Yes making this program wont be easy, because its the coding that originally made by IDM.
Hope this helps a bit.
 
Upvote 0
Thanks W,

Unfortunately I couldn't find a way to anticipate the URLs of the files are of different nature (.pdf, ,DOC, docx, etc..), the link displays the file, but only the .pdf files could be saved using the Acrobat dialog box that appears in the bottom, for the rest it would be required to select all, copy and paste to a new document, then save it.

By the way I asked the same question along other forums, should I load links to those as well?

Rgds!
 
Upvote 0
if you ever post it in another board/forum, You should give the links too.
You can validate it by validating the url or the downloaded file. *_.pdf would do the trick
 
Upvote 0

Forum statistics

Threads
1,215,663
Messages
6,126,097
Members
449,291
Latest member
atfoley16

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top