Ask Question Forum:
C
O
M
P
U
T
E
R
2
8
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Y-position of the mouse cursor
Attachment:===
saveas wbesite html page into our PC at VBA excel

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
Yeah that should work as well... I don't think there is an easy solution to view web source using wbExec. You might be able to download the entire document but I don't know if it would prompt save As dialog there is flag for disabling prompts but don't know if that would actually work for newer operating systems considering the security risks involved.
Yeah that should work as well... I don't think there is an easy solution to view web source using wbExec. You might be able to download the entire document but I don't know if it would prompt save As dialog there is flag for disabling prompts but don't know if that would actually work for newer operating systems considering the security risks involved.
Yeah that should work as well... I don't think there is an easy solution to view web source using wbExec. You might be able to download the entire document but I don't know if it would prompt save As dialog there is flag for disabling prompts but don't know if that would actually work for newer operating systems considering the security risks involved.
Yeah that should work as well... I don't think there is an easy solution to view web source using wbExec. You might be able to download the entire document but I don't know if it would prompt save As dialog there is flag for disabling prompts but don't know if that would actually work for newer operating systems considering the security risks involved.
Yeah that should work as well... I don't think there is an easy solution to view web source using wbExec. You might be able to download the entire document but I don't know if it would prompt save As dialog there is flag for disabling prompts but don't know if that would actually work for newer operating systems considering the security risks involved.