• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2404
  • Last Modified:

HTML Link for UPS tracking number

Hi, I need to create an excel spreadsheet that has clickable UPS tracking numbers. I have the tracking numbers, but need an HTML link template so people can click a link to see shipment status. Thanks in advance for any direction.
0
Mark B
Asked:
Mark B
1 Solution
 
nishant joshiTechnology Development ConsultantCommented:
might it an small project not a question.if you want to create just html page then go to word and inserts data and save your page as html.

Regards,
nishant
0
 
Jeffrey CoachmanCommented:
AFAIK, the UPS tracking number is click-able....

Try right clicking the Tracking number (link), and pasting the link location into Excel...
0
 
Ken SelviaRetiredCommented:
Not a SQL question, but you can create this formula in an Excel cell row 1;

=HYPERLINK("http://ups.com?trackingnumber=" & A1, "Track")
 
assuming A1 contains your tracking link. Copy down the formula to all of your other rows.
0
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
Mark BDirector ITAuthor Commented:
kselvia- that is what I am looking for. Your weblink did not seem to pass the trackingnumber url parameter to auto bring up the shipment information, but this seems to work: =HYPERLINK("http://wwwapps.ups.com/WebTracking/track?HTMLVersion=5.0&loc=en_US&Requester=UPSHome&WBPM_lid=homepage%2Fct1.html_pnl_trk&trackNums="&B2&"&track.x=Tracka", "Track")
0
 
Ken SelviaRetiredCommented:
glad to hear it. my example was just something I found when I googled for it. It was probably using an old URL.
0
 
Mark BDirector ITAuthor Commented:
Was looking for working UPS URL, but this pointed me in right direction and concept was what I was looking for.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now