No, the 35 is actually part of the web address when I
bring up the track and confirm. That was the entire web
address that I mentioned on my original post. I am then
wanting to put a tracking tracking number into the form
and "enter" for go (for instance EB123456789US, although
that is probably not a valid number). It could then pull
up the tracking information for the item. I could have a
list of tracking numbers in my excel sheet and be able to
click on that to bring up the information on the web for
the piece.
Thanks.
-----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
.
.