User Profile

Collapse

Profile Sidebar

Collapse
georges50
georges50
Last Activity: Oct 6 '10, 01:02 AM
Joined: Nov 3 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • georges50
    replied to How to collect data from a browser?
    The IE Browser window has an HTML data structure that you can access and manipulate programmaticall y. Get a copy of a Programmer's manuel for a recent version of HTML. THe one I'm using is IE5 Dynamic HTML Programmer's Reference by Brian Francis, Alex Homer and Chris Ullman. It describes the underlying data structure and gives some code examples to process it.
    See more | Go to post

    Leave a comment:


  • georges50
    replied to Screen Scraping
    Here is some VBA code that will grab an open IE Browser window on your desktop and return the document so that it can be scraped. Use the Tagnames and Innertext fields. You will need to handle frames on the page specially.
    This should get you going


    Code:
    Sub TstdcIEURL()
    Dim myObj As Object, ObjDoc As Object
    Dim myTagName As String, myInnerText As String
        'Set myObj = dcIEURL("replace
    ...
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...