Opening/saving a web page via VBA
 

From a range of text cells with hyperlinked web addresses I would
like, if possible, to

1. Click each cell to open the web page associated with the
hyperlink address...

2. Save the page as an archived .mht file to my local c: drive....

3. Then change the hyperlink address to the new c: drive address

Tried recording a macro with the above 1 & 2 actions and finished with
the following lines

Range("A1").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
Application.Goto Reference:="R1C1"

I'm completely lost on this.

TIA

Ron