Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to completely retrieve a web page and search it using
VBScript regular expressions. However, I do not get the complete web page. Am I running into some VBA string length limit or what? Is there some way around it? My Sub may be found below. Alan Sub GetGoogleHomePage() Dim oIE As SHDocVw.InternetExplorer Dim sPage As String ' Create a new (hidden) instance of IE Set oIE = New SHDocVw.InternetExplorer ' Open the web page oIE.Navigate "http://www.google.com" ' Wait for the page to complete loading Do Until oIE.ReadyState = READYSTATE_COMPLETE DoEvents Loop ' Retrieve the text of the web page sPage = oIE.Document.body.InnerHTML ' Display the HTML Debug.Print sPage End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I retrieve a page number in Excel? | Excel Worksheet Functions | |||
Cannot print a complete page of labels | Excel Discussion (Misc queries) | |||
Retrieve data from company intranet page | Excel Programming | |||
programmatically retrieve links from web page | Excel Programming | |||
Unable to print a complete workbook | Excel Discussion (Misc queries) |