View Full Version : IP Address Location and DNS

10-25-2008, 08:02 PM

I have a list of IP addresses from a website log. I want to be able to allocate the country, state, city and DNS for the IP address within a VBA module.

Following that I will use the data to populate a pivot table and chart for the statistics...

I can see the are a number of sites that let you get the information....but I have found any samples or examples of VBA script that achieves this or something similar...

Can anyone point me in the right direction to acheive this.


10-26-2008, 09:48 AM
Do you know any of thr criteria for example does the first part of the ip mean the country or does the second part of the ip mean the state or city and so on...

10-26-2008, 01:20 PM
No unfortunately that is not known.....and I think it may vary sometimes....it appears that there are databases available containing the information and you use the web queries to access it....I was wondering if someone in this community had built a routine to access those queries and if it could be re-used in my vba module...