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

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
.

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
.

.

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
.

.

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
.

.

.

Yes, that is what I am wanting to do. Click on a link in
excel, open a webpage, automatically put in the data that
goes in the box and enter. When I put in a tracking
number manually, the following page opens up. It does not
have the tracking number listed in the webaddress
though......

http://trkcnfrm1.smi.usps.com/netdata-
cgi/db2www/cbd_243.d2w/output



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

.

.

.

Oh :( The web site must be using cookies or something,
sadly I'm outta ideas, this sounds more like something VB
might be able to handle, but that's out of my league.

All I can do is wish you good luck.
- Andrew

-----Original Message-----
Yes, that is what I am wanting to do. Click on a link in
excel, open a webpage, automatically put in the data
that
goes in the box and enter. When I put in a tracking
number manually, the following page opens up. It does
not
have the tracking number listed in the webaddress
though......

http://trkcnfrm1.smi.usps.com/netdata-
cgi/db2www/cbd_243.d2w/output

There is NO ?question mark in there once I put in the
tracking number.
-----Original Message-----
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
.

.

.

.