Dear all,
I need some help and advice using VBA to create a URL.
I want to plot several points on Google Maps. The URL I am trying to create is this:-
http://maps.googleapis.com/maps/api/staticmap?zoom=12&size=800x800&markers=color:yellow%7CLS11+8QY&markers=color:red%7CLS10+1AZ&markers=color:red%7CLS11+7HG&sensor=false
String:-
http://maps.googleapis.com/maps/api/staticmap?zoom=12&size=800x800
Variables:-
&markers=color:yellow%7CLS11+8QY
&markers=color:red%7CLS10+1AZ
&markers=color:red%7CLS11+7HG
String (ending):-
&sensor=false
This plots three points on a map. I have created the above manually but I can't figure out how to get access to create it. I have a table that stores address/postcode data:-
[tbladdress].[postcode]
LS11 8QY
LS11 7HG
LS10 1AZ
How do I turn the three postcodes (above) into the url above using vba?
It's basically a string function but I do not know how to loop(?) the three records into one continuous string. I have searched and searched but I can't find the answer. Any help or guidance would be greatly appreciated.
Cheers
I need some help and advice using VBA to create a URL.
I want to plot several points on Google Maps. The URL I am trying to create is this:-
http://maps.googleapis.com/maps/api/staticmap?zoom=12&size=800x800&markers=color:yellow%7CLS11+8QY&markers=color:red%7CLS10+1AZ&markers=color:red%7CLS11+7HG&sensor=false
String:-
http://maps.googleapis.com/maps/api/staticmap?zoom=12&size=800x800
Variables:-
&markers=color:yellow%7CLS11+8QY
&markers=color:red%7CLS10+1AZ
&markers=color:red%7CLS11+7HG
String (ending):-
&sensor=false
This plots three points on a map. I have created the above manually but I can't figure out how to get access to create it. I have a table that stores address/postcode data:-
[tbladdress].[postcode]
LS11 8QY
LS11 7HG
LS10 1AZ
How do I turn the three postcodes (above) into the url above using vba?
It's basically a string function but I do not know how to loop(?) the three records into one continuous string. I have searched and searched but I can't find the answer. Any help or guidance would be greatly appreciated.
Cheers