ExcelBanter - VBA to save a web page to local disk

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - VBA to save a web page to local disk (https://www.excelbanter.com/excel-discussion-misc-queries/85347-vba-save-web-page-local-disk.html)

Ron

VBA to save a web page to local disk

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

All times are GMT +1. The time now is 05:26 AM.