View Single Post
  #3   Report Post  
Mary
 
Posts: n/a
Default

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
.

.