What I want is a button in Excel what takes two cell
values an inserts them in a web address and calls it in a
browser. For example:

Cell A1 = 526440
Cell B1 = 182376

Press button, internet opens with following address:
http://www.streetmap.co.uk/newmap.srf?
x=526440&y=182376&z=0&sv=526440,182376&st=4&mapp=n ewmap.srf
&searchp=newsearch.srf

This solution would go out to around 50 different
organisations, so the method used to call the internet
should be pretty common.

Thanks!

Actually it doesn't need to be a button -- it can be a
hyperlink or whatever else you can come up with. Just
needs to be able to dynamically create the web address.

-----Original Message-----
What I want is a button in Excel what takes two cell
values an inserts them in a web address and calls it in a
browser. For example:

Cell A1 = 526440
Cell B1 = 182376

Press button, internet opens with following address:
http://www.streetmap.co.uk/newmap.srf?
x=526440&y=182376&z=0&sv=526440,182376&st=4&mapp= newmap.sr
f
&searchp=newsearch.srf

This solution would go out to around 50 different
organisations, so the method used to call the internet
should be pretty common.

Thanks!
.

try
x=526440&y=182376&z=0&sv=526440,182376&st=4&mapp= newmap.sr
use
x="&[a2]&"&y=182376&z=0&sv="&[a2]&",182376&st=4&mapp=newmap.sr

where a2 contains 526440



--
Don Guillett
SalesAid Software

"Andrew Harder" wrote in message
...
Actually it doesn't need to be a button -- it can be a
hyperlink or whatever else you can come up with. Just
needs to be able to dynamically create the web address.

-----Original Message-----
What I want is a button in Excel what takes two cell
values an inserts them in a web address and calls it in a
browser. For example:

Cell A1 = 526440
Cell B1 = 182376

Press button, internet opens with following address:
http://www.streetmap.co.uk/newmap.srf?
x=526440&y=182376&z=0&sv=526440,182376&st=4&mapp= newmap.sr
f
&searchp=newsearch.srf

This solution would go out to around 50 different
organisations, so the method used to call the internet
should be pretty common.

Thanks!
.