get lat and long from ip address

I am looking to get the latitude and longitude from an ip address in vba.
thanks
SvgmassiveAsked:
Who is Participating?
 
als315Commented:
You can use freeip-api.com service, but it is limited to 150 requests per minute
Look at sample. Select cell with IP address and press button. Nect cells with IP will be filled with location
Sample_location.xlsm
0
 
Pawan KumarDatabase ExpertCommented:
Your question is very wide. Have your written any code ? Are you facing any specific issue?

You can refer this for getting Longitude and latitude in VBA. Need to consume this as a web service http://www.geonames.org/. Not very sure whether it is free or not.

http://www.expertinexcel.com/excel-vba/geography-and-ip-address-in-vba
0
 
Dave BaldwinFixer of ProblemsCommented:
IP addresses belong to ISPs.  You will normally be getting the ISPs location.
0
 
SvgmassiveAuthor Commented:
Awesome!!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.