Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,588
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,588
Default 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
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
How do I create a hyperlink for individual FedEx tracking numbers. robinrobin Excel Worksheet Functions 3 April 25th 23 07:48 PM
Automatic log-on to web site using hyperlink Pete_UK Excel Discussion (Misc queries) 0 December 1st 09 02:40 AM
Looking for Excel site similar to "The Word MVP Site" Doug New Users to Excel 1 January 25th 09 01:46 PM
How to insert tracking numbers into my webpage for RMA tracking wiglady Excel Discussion (Misc queries) 0 April 4th 06 12:44 PM
FTP site Gareth Excel Programming 1 January 12th 04 05:00 PM


All times are GMT +1. The time now is 07:42 PM.

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

About Us

"It's about Microsoft Excel"