mcomp72
Active Member
- Joined
- Aug 14, 2016
- Messages
- 275
- Office Version
- 365
- 2019
- 2016
- 2011
- Platform
- Windows
- MacOS
Hey everyone. I would like the data in a few cells of my worksheet to be a different, based on where the user is located. I want to use their IP address to find where they are, and have figured out how to get their External IP address using VBA. However, what I haven't been able to figure out yet is how to then get the Country, State, City, and Zip Code from that IP address. I'm sure it must be possible to query an online IP database somehow to get that, but I have never dealt with querying databases before, so I haven't a clue how to do it. I'm wondering if anyone already has some code that does this that they'd be willing to share?