0

So I have very little experience with web queries in VBA. Currently, I have a column of gecodes that require a satellite image of the location.

I want to use this website :http://google-maps.pro/satellite and search in the search bar, then return the resulting URL. Currently I have "http://google-maps.pro/satellite#" in one cell and concatenate it with the geocode, it does not work (although this works for other websites).

I am not sure if this is even a web query, as while learning I see that most web query scripts seem to focus on returning an html table, whereas I just want the URL. What exactly is it that I am looking for? Am I wasting time learning web querying with VBA?

EDIT: Solved, read URL wrong.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
J.H
  • 181
  • 5
  • 14
  • Could you please specify what are the geocodes you have and what is the expected result URL? – omegastripes Apr 25 '16 at 15:22
  • Actually I have realized that I am just stupid. The concatenate worked except I missed that there was a ",19" added to the end of every generated URL. – J.H Apr 26 '16 at 06:59

0 Answers0