button to call website

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

Andrew Harder

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

Don Guillett

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top