An update to the Shipment Tracking Add-In is available.
Links:
And for reference:
Shipment Tracking UserForm Add-In for batch tracking
New Features/Fixes:
- Now works with Conway and ABF
- FedEx tracking was fixed
- ABF shipment tracking uses InternetExplorer.Application Object instead of XMLHTTP
Special thanks to visitor Mike for making the above updates. Due to user request, I'll be updating it again to return the delivery date and other details.
[Update 2/14/2009]: I am actively seeking to build this application with more carriers; so far there are five, but I know there are more. If you would like your carrier added, please send me the carrier name, URL and some sample tracking numbers.
About JP
6 Comment(s) on Shipment Tracking Add-in Update:
Hi I downloaded the addin & installed as per the instruction. I was not able to get the desired results. It is saying "ERROR". more over the tracking number is of UPS & has 18 characters.
Please someone help me in this regard.
thanks in advance for all your support.
If you go to the UPS.com website and track it manually, do you get a result?
Hi thanks for your responce. the problem is I will be tracking more than 250 shipments per day. I taught of using excel addin to do all that in one go. in the web sit we can key max 25 tracking numbers at a time. if i accumulate the process per week i have to track more than 1000 shipments that makes complicated.
I request your support in fixing this issue.
thanks
Have a great weekend.
Kashinath
What I meant was, if you get an error message with a tracking number, check UPS.com to see if the problem is the tracking number, or the add-in. If you get a result from UPS.com, that means there's a technical problem with the add-in that needs to be fixed.
If you need to track multiple shipments, consider using the UI add-in which can track shipments in bulk. Download it here:
http://www.jpsoftwaretech.com/wkbks/ShipTrackUI.xla
You will need BOTH the ShipTrack add-in and the ShipTrack UI add-ins in order to do bulk shipments. See Shipment Tracking Userform for batch processing for instructions.
Hi, I am not able to accessthe link for UI Addin
http://www.jpsoftwaretech.com/wkbks/ShipTrackUI.xla
I am getting the messge as "you dont have permission to view.
Can you please senet it to my email it will be very help full.
the below are the sample tracking numbers for our reference.
1Z7AT3880244379837
1Z9498760241656801
Hi JP and Kashinath,
ShipmentUI addin is showing "RUNTIME ERROR 53", file not found
Further,
when I searched for the above Tracking no.(1Z7AT3880244379837) through shiptrack_unlocked 2003 I got the following response in the excel.
"Delivered on DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN>
<META HTTP-EQUIV=Content-Type CONTENT=text/html"
Please help us.
Regards,
Srinivasa