Courier Shipment tracking in excel

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Courier Shipment tracking in excel

  1. #1
    New Member
    Join Date
    May 2012
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Unhappy Courier Shipment tracking in excel

     
    I am trying to figure out from long time but not able to do it.I want to create a excel sheet in which a column will have tracking no. and the another column will have courier company name(DHL,FedEx,etc). The 3rd column should give me whether the shipment was delivered or in transit in real time by automatically going to corresponding courier company website and using the tracking no.Is there any way to do this?I am new to VBA and macros. So a detailed description would be appreciable.Thanx in advance.

  2. #2
    Board Regular
    Join Date
    Apr 2012
    Location
    Connecticut
    Posts
    251
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Courier Shipment tracking in excel

    Welcome to the board, vikash.

    That's one heck of an ambitious first question!

    I won't say that it's not possible to resolve, because I'm sure that someone with the right skills (and it looks to me like it's going to take a lot of skills) could probably do it. But it's very ambitious. I doubt if you'll find anyone on the board who'd be willing to take the time to develop an entire application like that for you just in their spare time and just for the heck of it.

    On the other hand, if you start the development yourself and have questions with particular - discrete - aspects of the question, well, we'd be very happy to pitch in with those more focused kinds of questions.

    And for all I know, because some of the people here do have awesome skills, someone might be able to write up code for exactly what you want, and deliver a polished, working, and bulletproof application. How much is that worth to you? Assuming that I could do that - I can't - I wouldn't do that for free, and I don't know anyone else who will, either.

    Here's wishing you better luck on your next question! And narrower scope ...

  3. #3
    Board Regular dave3009's Avatar
    Join Date
    Jun 2006
    Location
    Inverclyde, Scotland
    Posts
    6,996
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Courier Shipment tracking in excel

    Echoing the thoughts of BlueHornet on this one.

    I think, and it IS just a thought, you might be able to do this via an SQL connection or other external query connection. Have a look at Data>>Get External Data. If you think this might work you will probably need server connection permission (server name, username, password) which those companies should be able to provide you.

    Start going and see how you get on, ask any specific questions as you go. Good Luck!
    Please state your version of Excel, I use Excel 2007 on Win 10.
    Back up all data and test VBA code on a COPY workbook, and please use [code][/code] tags.
    HTML Maker | HTML Maker - FAQ

  4. #4
    New Member
    Join Date
    Jan 2013
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Courier Shipment tracking in excel

    Sorry to bump an old thread here guys, but it was pretty relevant and how I found the forum in the first place so I figured why not.

    I'm looking for a similar solution as the one requested. I'm using Excel 2010 and have a spreadsheet I use for incoming packages (mostly FedEx, UPS and few USPS). I have a scanner from Motorola to scan the tracking numbers. What I'm curious to is if anyone knows how I might go about making the spreadsheet such that after scanning the package, I could get the recipient and sender information automatically pulled from the courier sites into the spreadsheet?

    Thanks!
    - sheesh

  5. #5
    New Member
    Join Date
    May 2012
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Courier Shipment tracking in excel

    Quote Originally Posted by vikash6451 View Post
    I am trying to figure out from long time but not able to do it.I want to create a excel sheet in which a column will have tracking no. and the another column will have courier company name(DHL,FedEx,etc). The 3rd column should give me whether the shipment was delivered or in transit in real time by automatically going to corresponding courier company website and using the tracking no.Is there any way to do this?I am new to VBA and macros. So a detailed description would be appreciable.Thanx in advance.
    I don't know how safe the vba or programming is, but shiptrackaddin.com offers a free ad in that states it accomplishes this and offers the source code as freeware requesting a donation for use or if you like program.
    As they operate their own site, the safety of my own computer comes to risk but if you are able to go through the source code and ensure there is no malware included, it might be worth looking at.
    Do so at your own risk

  6. #6
    New Member
    Join Date
    May 2016
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Courier Shipment tracking in excel

    Bumping this thread because i want a similar functionality with Bluedart shipment tracking. As ahunter488 suggested, it is a good site but i don't think it's active anymore. You can try calling Aftership's api within VBA or there is another such site which offers similar api. Not sure if either of them work.

  7. #7
    New Member
    Join Date
    Nov 2017
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Courier Shipment tracking in excel

      
    Hi, how is your solution now? I know this is an old question, but still i want to share the fantastic courier shipment tracking tool i currently in using. Its name is TrackingMore. It provides tracking widget, courier tracking api and csv upload for people to track bulk packages. You can choose one or two or all which suit your needs.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com