R
Ron
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
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