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

Open each web page associated with the hyperlink address....

save the page as a .mht file to my local c: drive....

change the hyperlink address of each cell to the new c: drive address

TIA

Ron