VBA to save a web page to local disk

R

Ron

In a macro if I can open a web page with the following lines of code


' Sheets("Sheet3").Select
' Range("NewProps").Select
' Selection.Hyperlinks(1).Follow NewWindow:=True, AddHistory:=True


what code could I add to have the macro save the web page to my local
c:\documents and settings\Ron\My Documents\Data folder as a .mht file.

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

VBA Export to PDF 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
How can I get a Shareable URL via VBA code to a OneDrive image? 0
VBA to Save Web Pages 0
Saving web pages with VB possible? 0
Macro to Select text from a point given to a specific word 2
Opening/saving a web page via VBA 0
Print Macro 5

Top