Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open saved web page with ie
How do I open a saved webpage (eg, saved on my desktop) with Internet
Explorer using vb code? I want to be able to get the list of links from the page. I thought maybe I could use a shdocvw command, but not sure where to go with it. Is there a Help source anywhere for this library? Dim IE As New InternetExplorer ie.ExecWB(OLECMDID_OPEN, ?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open saved web page with ie
Hi shockley,
If you want to use IE only, then something like this should work (requires reference to shdocvw): Dim ie As InternetExplorer Set ie = New InternetExplorer With ie .Navigate URL:="c:\documents and settings\jmarx\desktop\test.htm" Do While .Busy And Not .ReadyState = READYSTATE_COMPLETE DoEvents Loop .Visible = True End With Set ie = Nothing Alternatively, you can use the built-in FollowHyperlink method: ThisWorkbook.FollowHyperlink "c:\documents and settings\jmarx\desktop\test.htm" Regards, Jake Marx MS MVP - Excel "shockley" wrote in message ... How do I open a saved webpage (eg, saved on my desktop) with Internet Explorer using vb code? I want to be able to get the list of links from the page. I thought maybe I could use a shdocvw command, but not sure where to go with it. Is there a Help source anywhere for this library? Dim IE As New InternetExplorer ie.ExecWB(OLECMDID_OPEN, ?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
saved hyperlinks don't open | Excel Worksheet Functions | |||
HELP WITH EXCEL SAVED AS WEB PAGE | Excel Discussion (Misc queries) | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
Excel files will not open in web page without being saved disk | Excel Discussion (Misc queries) | |||
Can't Open Saved File | Excel Discussion (Misc queries) |