Help woth geocoding, or reverse geocoding

Hi all,

I'm after another bit of help if possible,


My plan ideally is that when my operatives are on site, they need to use their laptop to open a connection, below is the code I'm currently to force the connection, its also getting IP information from them.

However what I would like to achieve, is somehow, be able to use geocode, to get their co ordinates, and basically tell me the street location they were in at the time.

Does that make sense?

Any help appreciated.

Below is the code I'm currently running (apologies if its messy) I'm new to this!

Please Login or Register  to view this content.

Sorry, but your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

EDIT:Thank you for now adding the code tags!

1. Click bottom right of your opening post to edit it.
2. Select all the text that is code.
3. Click on the # button on the toolbar to add code tags to it.
4. Review the forum rules.

Lovely - thank you.