Solved

HTML Link for UPS tracking number

Posted on 2012-03-20
6
1,722 Views
Last Modified: 2012-03-20
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
Comment
Question by:Mark B
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 14

Expert Comment

by:nishant joshi
ID: 37743946
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
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37744173
AFAIK, the UPS tracking number is click-able....

Try right clicking the Tracking number (link), and pasting the link location into Excel...
0
 
LVL 12

Accepted Solution

by:
kselvia earned 500 total points
ID: 37745009
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
Business Impact of IT Communications

What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.

 

Author Comment

by:Mark B
ID: 37745056
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
 
LVL 12

Expert Comment

by:kselvia
ID: 37745108
glad to hear it. my example was just something I found when I googled for it. It was probably using an old URL.
0
 

Author Closing Comment

by:Mark B
ID: 37745129
Was looking for working UPS URL, but this pointed me in right direction and concept was what I was looking for.
0

Featured Post

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question