Solved

HTML Link for UPS tracking number

Posted on 2012-03-20
6
1,475 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
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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

777 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