View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ron
 
Posts: n/a
Default 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