Opening/saving a web page via VBA

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top