Opening Web Page AND Getting Result

[Michael]

I need to convert a street address into its Longitude and Latitude
coordinates. There is a web site I can call where I pass the street's
address and it will return in the web page a single line of text containing
the result of my search. To see what I mean, to get the Longitude and
Latitude coordinates of the White House, you would go to
"http://rpc.geocoder.us/service/csv?address=1600+Pennsylvania+Ave,+Washington+DC".

How do I use VBA to open this web site AND read the result? Is there anyway
to do this behind the scenes so the user of my database doesn't see a web
page open and close?

Thanks,

Michael

 

[Douglas J. Steele]

See whether my November, 2003 "Access Answers" column in Pinnacle
Publication's "Smart Access" helps. Unfortunately, the sites on which the
examples are based have changed since the article was published, but you
hopefully can figure out what needs to be done from the text.

You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html

 

[Michael]

That works! Thanks.

See whether my November, 2003 "Access Answers" column in Pinnacle
Publication's "Smart Access" helps. Unfortunately, the sites on which the
examples are based have changed since the article was published, but you
hopefully can figure out what needs to be done from the text.

You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html