VBA to save URL pages

I have a list of URLs in Excel.
I'm looking for a code that would tell excel to go to each URL and save it as an HTML. I don't care to much where it saves it to, the default will probably be for it to save the URLs to MY Favorites folder whic is fine, and the file name it uses is irrelevant, the dafault name is fine here too.
Anyone know how to do this?

Others may know better than I ... but the below is as automated as I can get this:

Please Login or Register  to view this content.

And you have to set the reference to MS internet controls (I suggest you do this on open ... I don't know how persistant it is):

Please Login or Register  to view this content.

The code above is supposed to not prompt the user for a filename, but it does for some reason - anyone know why? I've also tried not making the page visible, but that just hangs.

But hopefully it will point you in the right direction ... MM.

You have to run the code in workbook open first ... this will set up the ie references

And change i=1 to i=2 at the top and also the URL line at the bottom from A to D .. that will take care of your issue about the URLs being in col D.

I'm totally screwing this up. I've got the code setup as you see below and I think this is how you meant I should do it but I'm getting a "USER DEFINED TYPE NOT DEFINED" Compile error for 'New InternetExplorer"

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Are you running the code in workbook_open first? To do this, either:
1. save the file as it is, then open it to activate the on open module, or
2. copy & paste the on open code into some other (non-event) module and run it normally.

This should set your references up and allow the 2nd lot of code to be run ... I'm assuming you're getting error when running the main code and not the smaller code? If so, the above should sort this out

hmmm ... in that case, try something like:

Please Login or Register  to view this content.

Hope that helps.