Forum Discussion
Soran0311
May 20, 2021Copper Contributor
Macro to auto calculate distance on google maps?
Hello again,
I would like to know if it's possible to automatically bring the search result from google maps (or other applications such as bing, etc...) into a specific cell.
For example, in my sheet 1 I have "Paris" in cell A1 and "Lyon" in cell B1, and I want to show the distance between two cities in cell C1. Here, I need the driving distance, and not the lineal distance...
Also, the cities could change in the next sheet..
Every help would be greatly appreciated, thank you in advance ...!
x_sysadmin_x Yes, this is something you can do. The feature you are looking is a Call Queue. The setting that allows individual group members to enable and disable calls is "Agents can opt out of taking calls" setting. Here are the docs: Create a call queue in Microsoft Teams - Microsoft Teams | Microsoft Docs
If you wanted calls to only be routed to these users outside of regular business hours, you could combine this with the Auto Attendant feature. In the "Call flow for after hours" section of the Auto Attendant wizard, choose the option to have calls redirected to the call queue. Set up an auto attendant for Microsoft Teams - Microsoft Teams | Microsoft Docs
We just have one person on call for a week at a time, so we just configure the "Call flow for after hours" on the AA to forward the after hours calls directly to that individual, and whoever is on call reconfigures the AA when their rotation starts.
1 Reply
Sort By
You will need to get an API key before you can use the code.
See Excel Function to Calculate Travel Time and Distance using Google Maps API with VBA