Asked by duncanb7
at 2024-07-04 05:36:53
Point:500 Replies:6 POST_ID:828355USER_ID:11059
Topic:
Visual Basic Programming;;Hypertext Markup Language (HTML)
I would like to save the wbesite as html file and save it in my PC .How Can I can do
that after the following code sub, "savewebsite". That is same operation when we save the website in IE window to our local PC dir and file but now it is saving it at
VBA excel
THe question-1, how to save the file by saving myie.document.innerhtml to example.html file when navigate is successfully ?
The question-2 how to use myIe.execWB OLECMDID_SAVEAS to save the website
into html file on PC
The question-3, What or Why is different using myIE.doucment.innerhtml and execWB to save the website into file ?
Please advise
Duncan
Sub savewebsite()
Dim myIE As SHDocVw.InternetExplorer
Set myIE = CreateObject("InternetExplorer.Application")
with myIE
.Visible = True
.navigate "www.yahoo.com"
Do Until Not .Busy And .readyState = READYSTATE_COMPLETE Loop
save code here
End with
End sub
that after the following code sub, "savewebsite". That is same operation when we save the website in IE window to our local PC dir and file but now it is saving it at
VBA excel
THe question-1, how to save the file by saving myie.document.innerhtml to example.html file when navigate is successfully ?
The question-2 how to use myIe.execWB OLECMDID_SAVEAS to save the website
into html file on PC
The question-3, What or Why is different using myIE.doucment.innerhtml and execWB to save the website into file ?
Please advise
Duncan
Sub savewebsite()
Dim myIE As SHDocVw.InternetExplorer
Set myIE = CreateObject("InternetExplorer.Application")
with myIE
.Visible = True
.navigate "www.yahoo.com"
Do Until Not .Busy And .readyState = READYSTATE_COMPLETE Loop
save code here
End with
End sub
