Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 406
  • Last Modified:

vb read table from IE web page

Hi,
     I wrote this piece of code to connect to explorer, open a webpage, and copy data from there by searching for a field name...What is the easiest or efficient way to copy data from a table located on a web page ?

Dim oIE, oIEDoc
Dim aInput As Variant
'Create the IE Application object
Set oIE = CreateObject("InternetExplorer.Application")
oIE.Visible = True

'Load page with data
oIE.Navigate ("http://172.20.41.11/test/FGPH_Detail.asp?varCrit=test-1Z&submit1=Submit+Query")
'Wait for page to load
Do While (oIE.ReadyState <> 4)
Loop

'Capture the IE document
Set oIEDoc = oIE.document
Set oBody = oIEDoc.Body
'Field Name
Text = "Customer Name"
dietype = InStr(oBody.innerText, Text)

oIE.Quit
Set oIE = Nothing
0
azcalv408
Asked:
azcalv408
1 Solution
 
jomacincCommented:
I would use the Internet Transfer Control to get the full HTML source of the page, you can then use string manipulation to extract the parts you need. This would save you the massive overhead of loading IE (uses far too much memory and processor time for the basic purpose it serves).

Presuming you had an Internet Transfer Control on yourt form called "Inet1":

'-----------------------------------------------------------------------------------
    Dim sHTMLSource  As String
    sHTMLSource = Inet1.OpenURL("http://www.someurl.here", icString)
'-----------------------------------------------------------------------------------

Regards, Jomac.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now