How to d/load & save web pages w/VBA?

R

Ron

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
 

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

Similar Threads

Opening/saving a web page via VBA 0
Capturing web page load times from VBA 3
Grouping Names in Mail Merge 0
Replace Hyperlink Addresses Help 'Dim OldStr As String, NewStr As String 6
VBA to Save Web Pages 0
Copying web pages onto Excel Spreadsheets using VBA 5
How to Change ALL Hyperlink Addresses in a Column? 8
How to write a VBA program to load the webpages automatically 1

Top