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