I am trying to get lat/long values from Google's Map API. I have no trouble creating the IE object in Excel and opening the browser but I'm having a heck of a time navigating the returned XML document to get the values I need.I have created the HTMLDocument and the reference appears to be valid but I'm stumped how to navigate it. Is there a way to obtain a string of the entire HTML output? From that I can get what I need.
Navigate IE XML document from within VBA?
- Thread starter Herooo
- Start date