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
Bookmarks