+ Reply to Thread
Results 1 to 1 of 1

Use VBA to extract certain data from the WhoIs Web Site

  1. #1
    Forum Contributor
    Join Date
    12-26-2010
    Location
    Kansas City, Kansas
    MS-Off Ver
    Excel 2007
    Posts
    147

    Use VBA to extract certain data from the WhoIs Web Site

    I have a web site and therefore can see the URL's that visit it.

    I am attaching a WB that already reads URL numbers into the WhoIs web site
    so that I can visually see who visited the web site.

    If you are a novice - I commented the code - and it might jump start you in terms
    of using VBA to play with a web page. WARNING: I don't use local variables -
    just module level variables so don't let this confuse you.

    I am seeking previously written code by anyone - to perform the following tasks.

    '---- Retrieve the H3 object on the page. It contains the IP ADDRESS

    '---- Retrieve the value of the Country:

    '---- Do a find on the IE document for countries like France/Germany/Israel/Syria/Jordan etc
    ' and if found - is there some way to GRAB the whole page and then Paste it to
    ' an on the fly new worksheet. IOW - like Document.Copy

    I have made NO ATTEMPT to code the above because after wasting hours trying
    to make the Web document scroll down based on google searches (its in the code in the WB)
    well - its like fighting the Borg.

    IE_WhoIs.document.parentWindow.scroll 0&, 400&

    This part does not appear in intellisense .....
    .parentWindow.scroll

    Note: I use early binding - so these are used in the attached WB
    'MS HTML OBJECT LIBRARY
    'MS HTML INTERNET CONTROLS

    Thanks in advance if anyone has and decides to share their code.

    regards
    John
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 07-24-2013, 11:16 PM
  2. [SOLVED] Vba to extract data from a web site
    By franunzio in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-28-2012, 08:00 PM
  3. auto extract data from web site
    By plato in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-31-2011, 06:02 AM
  4. Site to Site concurrent call calculation
    By msknja in forum Excel General
    Replies: 5
    Last Post: 08-29-2010, 08:34 PM
  5. i made site! Good Site. Look now mysite!!!
    By joks3xxx in forum Excel General
    Replies: 0
    Last Post: 08-10-2006, 03:47 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1