Ok, so when you (manually) go to the trackandconfirm.htm
page, enter in the appropriate tracking number and click
the Ok / press [Enter], does your web browser not then
show a URL which as a question mark somewhere in the
middle with any number of "something=somethingelse", could
you not then construct that with the concatenate?
Or maybe I'm missing your point? I'm thinking what you
want to do is launch a web page off an Excel spreadsheet
with all the details "gathered" from cell so the user
doesn't have to manually data enter details which already
exist within your spreadsheet.
- Andrew
-----Original Message-----
I did just go back into the track and confirm page on the
web, and this is all that is needed to get there. I am
now just trying to figure out how to enter the tracking
number into their form and press enter, all from excel.
The 35 thingie isn't needed, but it wasn't the tracking
number either.
thanks again!
http://www.usps.com/shipping/trackandconfirm.htm
-----Original Message-----
Would using a Concatenate help?, something like:
=HYPERLINK(CONCATENATE
("http://www.usps.com/shipping/trackandconfirm.htm?
from=home&page=",TEXT
(A3,"###0"),"trackandconfirm"),"Click
here")
I'm assuming it's the page number that's changing and
that
that A3=35, but you should get the idea anyway.
- Andrew
-----Original Message-----
I am able to make a hyperlink function to open a
webpage,
but I am wanting to be able to go webpage by clicking
on
the link and automatically put in a tracking number and
press go:
http://www.usps.com/shipping/trackandconfirm.htm?
from=home&page=0035trackandconfirm
Is there a way to do this with the hyperlink function?
I
do not know VB yet, so wouldn't even know where to
start
in that.
Thanks
.
.
.