Trying to download Files From the Web and Save on a Directory

Hi,

I am trying to create a macro that will open a .xls file, download all the files linked on that file, close it and move to the next, however I can't seem to make the excel accpet downloading files that are pdfs, jpgs and so on. Can anyone help me? The code so far is the following:

Please Login or Register  to view this content.

Thanks for the help

I have managed to make it work. The Code ended up like this.

Please Login or Register  to view this content.