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 »



Share This Article:

Share and bookmark this articledelicious buttonfacebook buttonlinkedin buttonstumbleupon buttontwitter button

comment bubble 22 Comment(s) on ShipTrack 4.2 Now Available:

  1. 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

  2. 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.

  3. Ivan Cavaliere writes:

    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?

  4. Ivan Cavaliere writes:

    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

  5. Michael writes:

    Is there anyway to grab the "Pickup Scan" date and time for UPS?

  6. 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

    • Which version(s) of Excel do you have and did you download the correct version?

      • 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.

  7. 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

  8. Zurab null null writes:

    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

  9. 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.

  10. Ivan Cavaliere writes:

    Would you consider doing an update to MS 2010 any time soon please?

  11. 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.

    • 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.

    • 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.

This article is closed to any future comments.
excel school learn dashboards