get text info from webpage into my text field

[PATRICK]

Im trying to get information from webpage. (http://benwerd.com/lab/geo.php)

Im using the code:
Set ie = CreateObject("internetexplorer.application")
ie.Visible = True


ie.Navigate "http://benwerd.com/lab/geo.php"
While ie.Busy
DoEvents
Wend
Me.txtlat = ie.Document.getElementById("xxxxxxx").... here is the info I can't get from the page. Can't find the id or element that hold the information, latitude, longitude ... that is listed in the website.

[June7]

I tried that link in IE and get message that my browser does not support geolocation. Firefox and Chrome message is 'Waiting for browser...', nothing happens. Guess I am way out of date. Will try another computer later.

Did you View Source from IE? Can't find the elements in Source?

Review

https://www.accessforums.net/import-...ite-25688.html

https://www.accessforums.net/forms/a...her-34620.html

[PATRICK]

Yes I did. but the information is kind inside of a jquery script or something, there''s no Id where I could get the info. basically the geolocation function is from webbroser. I'll paste here part of the source code:



<scriptlanguage="javascript">




/*

* The interesting stuff starts here ...

*/



// This is just to show the Google Map - not related to the HTML5 geolocation API


function googleMapShow(lat,long) {


var latlng = new google.maps.LatLng(lat, long);


var myOptions = {

zoom: 14,

center: latlng,

mapTypeId: google.maps.MapTypeId.ROADMAP

};


var map = new google.maps.Map(document.getElementById("map_canvas"), myOptions);

}






// Use jQuery to display useful information about our position.


function exportPosition(position) {

$(
'#georesults').html(


'<div id="map_canvas" style="float: right; width: 200px; height: 200px"></div>' +


'<p>'

+
'Latitude: ' + position.coords.latitude + '<br />'

+
'Longitude: ' + position.coords.longitude + '<br />'

+
'Accuracy: ' + position.coords.accuracy + '<br />'

+
'Altitude: ' + position.coords.altitude + '<br />'

+
'Altitude accuracy: ' + position.coords.altitudeAccuracy + '<br />'

+
'Heading: ' + position.coords.heading + '<br />'

+
'Speed: ' + position.coords.speed + '<br />'

+
'</p>'

);

googleMapShow(

position.coords.latitude,

position.coords.longitude,

{maximumAge:600000});

}

[June7]

On another computer now. The site wants to 'track my location', I say no and nothing happens except it says "The page could not get your location". Refreshing or reopening the page doesn't change that message. Not another chance to say yes? What is this site for?

[PATRICK]

You have to say Yes... the site gives your current location using google maps (latitude, longitude...) so, I need this info to track information into my database, this is new feature on html5 but google api doenst have option for vba, so I need to call this web and get the info from there, or any other web, as long it give me the geolocation... I can even do my own page and put it in a server just so only myself will access to have the geolocation that works in html5 against google mapgs... you can say yes after that you will see the source code.

To have the website ask you again, go to internet options, Privacy, and unmark "Never allow web to request location" and "clear sites".... you should be asked again after that.

[June7]

Searching the html source behind the page won't work because the lat/long values are not actually there, only variables in a jquery script, as you noted. The View Source is just text, the variables displayed aren't really populated with data. Have to search the rendered web page, not the source view, and since there is no elementID, as you also noted, there is nothing to reference.

I found this for Excel http://xlvba.fr.yuku.com/topic/33#.UgW_hV_TmCh
It displays the page but page says "Waiting for browser ..."
I did get this to work with a different website page.

I tried using Access Web Browser control.
It displays the page but page says "Your browser does not support geolocation".

This looked promising http://www.mrexcel.com/forum/excel-q...xt-string.html
I adjusted the code to run in Access.
With the benwerd.com page code runs without error but no results returned.
However, again, it worked beautifully with a different website page, one that does not need authorization response from client.

What is really needed is an API that downloads the data into xml, like shown in the second link I provided earlier.