get lat and long from ip address

Svgmassive
Svgmassive used Ask the Experts™
on
I am looking to get the latitude and longitude from an ip address in vba.
thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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
Pawan KumarDatabase Expert
Awarded 2016
Top Expert 2016

Commented:
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
Dave BaldwinFixer of Problems
Most Valuable Expert 2014

Commented:
IP addresses belong to ISPs.  You will normally be getting the ISPs location.

Author

Commented:
Awesome!!!!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial