LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Mary
 
Posts: n/a
Default

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
.

.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing hyperlink Frank Marousek Excel Discussion (Misc queries) 3 January 12th 05 09:53 PM
I cant use englisch function names in a swedich version of excel PE Excel Discussion (Misc queries) 2 December 7th 04 01:00 AM
carrying a hyper link when using the vlookup function mike Excel Worksheet Functions 1 November 19th 04 03:49 AM
Counting Function Dilemma Simon Lloyd Excel Worksheet Functions 0 November 8th 04 03:13 PM
function about hyperlink Poon Xiulok Excel Worksheet Functions 4 November 1st 04 05:42 PM


All times are GMT +1. The time now is 09:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"