Home |
Search |
Today's Posts |
#4
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Removing hyperlink | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
carrying a hyper link when using the vlookup function | Excel Worksheet Functions | |||
Counting Function Dilemma | Excel Worksheet Functions | |||
function about hyperlink | Excel Worksheet Functions |