ShipTrack 4.2 Now Available

March 25, 2011 by JP

22 Comment(s)

ShipTrack Update

ShipTrack 4.2 is now available, with support for TNT and YRC.

Visit those websites for a list of supported regional carriers.

Download ShipTrack

Filed Under: AddIns, Excel

Tagged With: addin, ShipTrack

About JP

I'm just an average guy who writes VBA code for a living. This is my personal blog. Excel and Outlook are my thing, with a sprinkle of Access and Word here and there. Follow this space to learn more about VBA. Keep Reading »

February 4, 2013 -- ShipTrack 4.2.5 now available
January 25, 2011 -- ShipTrack and a few other updates
April 21, 2012 -- An update to ShipTrack 4.2.2 is now available

Share This Article:

22 Comment(s) on ShipTrack 4.2 Now Available:

Ryan writes:

June 1, 2011 at 11:37 am

Is there something special I have to do for this to work with FedEx ground tracking numbers? It seems to work fine with Express tracking but Ground returns blanks. Sample tracking number:

590540310038143
Erik writes:

June 9, 2011 at 3:42 pm

This add in is awesome–very useful!! It is working well for fedex, ups, and conway, in my spreadsheet, but YRC is yielding #Value! for all tracking numbers (1130585164, for example).

Any ideas what's wrong? I suspect YRC changed their site, but don' t know how to correct this.
Ivan Cavaliere writes:

June 22, 2011 at 5:24 pm

I downloaded the software, ran the installation program and, everything looked like worked out fine but, when I enter the formula in Excel it returns a #N/A value. I went into the add-ins and see no add-in being installed.

Can you please help me understand why it didn't work.

Thank you,

Ivan
PS If I want the VBA Code, how much would you expect for it please?
Ivan Cavaliere writes:

June 22, 2011 at 6:26 pm

I found the problem, it was at my end.

Your software works great and has really helped me solve a problem I had carrying on for a long time.

I am still interested in buying the code, please let me know how I go about it.

Thank you,

Ivan
- JP writes:
  
  June 23, 2011 at 9:43 pm
  
  The article contains links to download the unlocked source code. If the addin has helped you, feel free to donate at that time, or visit http://www.jpsoftwaretech.com/out/donate to contribute something later. Thx
Michael writes:

June 22, 2011 at 8:56 pm

Is there anyway to grab the "Pickup Scan" date and time for UPS?
- JP writes:
  
  June 23, 2011 at 9:44 pm
  
  Yes but I assume the pickup scan occurs on the same day as shipment?
Chad writes:

June 23, 2011 at 5:23 pm

Hi -

I get the error msg- "This add in will only work in Excel 2007" after installion

Happy to donate if you have a answer-would save us a ton of time.

Thanks
- JP writes:
  
  June 23, 2011 at 9:45 pm
  
  Which version(s) of Excel do you have and did you download the correct version?
  - Chad writes:
    
    June 24, 2011 at 9:43 am
    
    Hi- using Version 14.05128.5000 32 Bit
    
    I downloaded ShipTrack 4.2 and it seems to install fine I just get the error pop up when I have the add in selected and open excel.
    - JP writes:
      
      June 25, 2011 at 10:33 am
      
      I assume you mean Excel 2010. ShipTrack is only available for Excel 2000-2007 at this time.
Beau writes:

July 14, 2011 at 5:16 pm

JP,
I downloaded 4.2 and it added fine, I can see it in the addins.
The problem is whenever I put the formula =ShipTrack(B17,"FedEx") into a cell it doesn't return anything at all. Typically I should get an error of some sort but it's like it's working but there's no output.

B17 is where the tracking number is
- JP writes:
  
  July 18, 2011 at 6:35 pm
  
  Can you provide the tracking number via PM? Contact
  - beau writes:
    
    July 21, 2011 at 2:06 pm
    
    Got it working now….thanks!
Zurab null null writes:

July 21, 2011 at 12:40 am

Hi JP,

It is grate addin. I work with UPS, DHL and FedEx tracking numbers. UPS and DHL works just fine but FedEx giving me hard time. All FedEx numbers show none/blank result… What could it be? Is anybody else having the same problem? Please advise.

Work on XP Excel 2003
- JP writes:
  
  July 22, 2011 at 6:45 pm
  
  Do you have a recent tracking number?
Eric writes:

August 4, 2011 at 11:23 am

The UPS website has seemed to move where you were picking up the the delivery date. All I get back now is a "Delivered" message without the delivery date. Is there an update or another way to get the delivery date as this information is very useful in establishing timelines for my projects.
Ivan Cavaliere writes:

August 5, 2011 at 10:52 am

Would you consider doing an update to MS 2010 any time soon please?
- JP writes:
  
  August 6, 2011 at 9:49 am
  
  As soon as Random Data Generator is updated.
ken writes:

January 28, 2012 at 2:30 am

Hi JP,

The plug in is great! thank you, I'm using excel 2007 and having problem in USPS.
it returns "Arrival at Unit" but it returns "error" if the status on usps.com is "Delivered"

example:

RB369571685HK arrival at unit
RB369571677HK delivered
RB369571694HK delivered

only the first tracking work in excel, the other 2 are "error"

I mean the formula(tried both trackUSPS and shiptrack(trackNum, "USPS") only work if the status of the shipment is "arrival at unit", the first tracking # works fine and will return "arrival at unit", the other two shipments have "Delivered" in status on USPS.com, and they both are returning "ERROR" in excel.
- ken writes:
  
  January 28, 2012 at 2:33 am
  
  I mean the formula(tried both trackUSPS and shiptrack(trackNum, "USPS") only work if the status of the shipment is "arrival at unit", the first tracking # works fine and will return "arrival at unit", the other two shipments have "Delivered" in status on USPS.com, and they both are returning "ERROR" in excel.
- JP writes:
  
  January 30, 2012 at 9:28 pm
  
  Are you using the source code? If you are using the addin (not the source code), please only use the "ShipTrack" method. I have locked down the addin so that is the only way to use the addin (my mistake for exposing internal methods). Let me check on those tracking numbers and see what is going on.