button to call website

  • Thread starter Thread starter Andrew Harder
  • Start date Start date
A

Andrew Harder

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.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.
 
try
x=526440&y=182376&z=0&sv=526440,182376&st=4&mapp=newmap.sr
Click to expand...
use
x="&[a2]&"&y=182376&z=0&sv="&[a2]&",182376&st=4&mapp=newmap.sr

where a2 contains 526440
 
Back
Top