VBA: Getting Data from Invisible Web page...
Hello,
I am using the following code to grab data from a webtable from a Fitch report:
Set oIE = New SHDocVw.InternetExplorer
oIE.Navigate Navigateto
Do Until oIE.ReadyState = READYSTATE_COMPLETE
DoEvents
Loop
Spage = oIE.Document.body.innerhtml
After which I can just search through the HTML source to find the data I need.
The problem I'm having is that when I try to do the same on absnet the data that I need is not in the document.body.innerhtml code. It is on WebTable("14"). Does anyone know the name that I need to put after oIE.(name here) in order to point Spage to the webtable("14") html source code? Thanks!
|