I did a little more research on this. Google provides a Web API for Plus Codes. You can easily implement a WebAPI in VBA using MSXML 6.0. Example below. You embed the address in the url. You need to encode address string like substitute + for space. You also embed the your encrypted key and email address. You need to have an account with Google Maps to get your key. I don't have Google Maps account so I wasn't able to test it.
Sub GetPlusCode()
Dim xmlhttp As New MSXML2.XMLHTTP60 'Reference MSXML 6.0
Dim url As String
url = "https://plus.codes/api?address=201+Palm+Desert+Dr.%2CGarland+TX&ekey=YOUR_ENCRYPTED_KEY&email=myemail@gmail.com"
xmlhttp.Open "GET", url, False
xmlhttp.setRequestHeader "Content-Type", "text/json"
xmlhttp.setRequestHeader "User-Agent", "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.127 Safari/537.36 Edg/100.0.1185.50"
xmlhttp.send
MsgBox (xmlhttp.responseText)
End Sub
Bookmarks