Hello:
I have excel sheet with lots of data in
Column A : Date (example 5/22/2012)
Column B : ip Address (example 95.87.232.168)
I need to know if it is possible to create a VB Code which will
go to one of the ip Tracer website (http://www.ip-adress.com/ip_tracer/) and paste country name
in column C where the ip was originated.
Thanks in Advance
Riz
Make sure there is nothing in column B except IP addresses, then try this:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Please Login or Register to view this content.
My way:
@snb, IE automation? Really? eughPlease Login or Register to view this content.
Hello All:
Thank you all so much for helping.
However, i see 1 problem that these website only allows 50 ip tracer.
i have lots of ip address..
Any idea how to come about this problem.
Thanks a lot
Riz
Hello All:
It looks like http://www.iplocation.net/index.php does not have any limitation.
Can you help me getting country using this site.
Thanks.
Riz
How many IPs? The original site actually gives you 200 per day once you register for free.
Hi:
I have over 10,000 ip address's//
Riz
Any IP Tracer web site you can find that includes the IP searched in the address URL we can adapt my macro to. The second site you listed does not, it masks the input field.
Jerry, you can post using query tables:
Although I'd prefer an adaptation of my original:Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks