Getting Internet Data Into The Listbox or Table

[Legacy 389185]

Hey, so I wrote a code for getting into the google maps site after typing 2 countries with a slash in the middle of them into a text box and when I press my "map" button, explorer launches and connects to google maps with the distance between these two places. My code is like this; (my button name is map and my textbox name is country)

-----------------------------------------------------------
Private Sub map_Click()


Dim country As String
Dim link As String


On Error GoTo myErr


ulke_ara = Me.country
link2 = "https://www.google.com/maps/dir/"
Application.FollowHyperlink link2 & country




On Error GoTo 0


Exit Sub


myErr:


Resume Next


End Sub

---------------------------------------

So is there a way that I can get these distance information back to access form (preferably in a text box) when I press the map button?

I think its something like impossible but I need to do it haha

 

[xenou]

Got me, but I don't know if it would work. For instance, distance between New York City and Montreal is approx. 370 miles and distance between Whitehorse and Houston is approx. 2800 miles but both are "distance between USA and Canada". Seems like there are a variety of distance calculators on the web, anyhow.