scott56
10-25-2008, 08:02 PM
Hi,
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.
Regards
Scott
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.
Regards
Scott