Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hyperlink to UPS tracking web site
I need to enter a UPS tracking number into a cell and then create a hyperlink
that concantinates the tracking address and the cell contents. any suggestions? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
hyperlink to UPS tracking web site
No idea what the tracking URL is like but this might do the job
=HYPERLINK("http://ups.com?trackingnumber=" & A1, "Track") Where your tracking number is in A1 -- Tim Williams Palo Alto, CA "cbrah" wrote in message ... I need to enter a UPS tracking number into a cell and then create a hyperlink that concantinates the tracking address and the cell contents. any suggestions? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
hyperlink to UPS tracking web site
Thanks, that seems to do it. Any suggestions on how I can automate this
hyperlinking, so that I can enter (Scan in) a tracking number and have the hyperlink automatically concantinate the web address and the number. This is what I'm building as the correct URL: "1za33f211346428299" - is what is seen in the cell. It is also what I have optically scanned from the airbill. " http://wwwapps.ups.com/etracking/tracking.cgi?TypeOfInquiryNumber=T&InquiryNumber1= 1za33f211346428299" - is the hyperlink address. I'll have a dozen or so a day, so if I can automate the process it will help. "Tim Williams" wrote: No idea what the tracking URL is like but this might do the job =HYPERLINK("http://ups.com?trackingnumber=" & A1, "Track") Where your tracking number is in A1 -- Tim Williams Palo Alto, CA "cbrah" wrote in message ... I need to enter a UPS tracking number into a cell and then create a hyperlink that concantinates the tracking address and the cell contents. any suggestions? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
hyperlink to UPS tracking web site
=IF(isblank(A1),"",HYPERLINK("http://ups.com?trackingnumber=" & A1,
"Track")) will only display a hyperlink if there is a tracking number. How are you entering the tracking numbers? You could add some code to the worksheet_change event to insert new links when new numbers appear. Tim. -- Tim Williams Palo Alto, CA "cbrah" wrote in message ... Thanks, that seems to do it. Any suggestions on how I can automate this hyperlinking, so that I can enter (Scan in) a tracking number and have the hyperlink automatically concantinate the web address and the number. This is what I'm building as the correct URL: "1za33f211346428299" - is what is seen in the cell. It is also what I have optically scanned from the airbill. " http://wwwapps.ups.com/etracking/tracking.cgi?TypeOfInquiryNumber=T&InquiryNumber1= 1za33f211346428299" - is the hyperlink address. I'll have a dozen or so a day, so if I can automate the process it will help. "Tim Williams" wrote: No idea what the tracking URL is like but this might do the job =HYPERLINK("http://ups.com?trackingnumber=" & A1, "Track") Where your tracking number is in A1 -- Tim Williams Palo Alto, CA "cbrah" wrote in message ... I need to enter a UPS tracking number into a cell and then create a hyperlink that concantinates the tracking address and the cell contents. any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a hyperlink for individual FedEx tracking numbers. | Excel Worksheet Functions | |||
Automatic log-on to web site using hyperlink | Excel Discussion (Misc queries) | |||
Looking for Excel site similar to "The Word MVP Site" | New Users to Excel | |||
How to insert tracking numbers into my webpage for RMA tracking | Excel Discussion (Misc queries) | |||
FTP site | Excel Programming |