Save a web Page as a HTML

Hi All,

I've attached a Macro which works great in looping through a spreadsheet and saving all the webpages to html.

Currently it is requiring a Save As pop up box and i'm hoping this can be adjusted to save the files automatically to a specific folder and name as shown in the spreadsheet.

Any help would be much aprreciated

Website Save Trial.xlsm

Cheers in advance

Thanks for the reply,

I also require all Images within the desired web page, this appears to just capture the text?

Sorry if i miss read the code within the web link!

Appreciate the help

Is there away to capture all the web page info, My Macro in the spreadsheet above allows html complete download including images.

Seem to find a lot of similar requests for this e.g.save webpage to PDF Word etc, but it appears to be difficult.

Cheers