button to call website
 

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!

button to call website
 

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!
.

button to call website
 

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!
.