• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to extract shipment tracking data from a website using VBA and without opening browser?

S

shazzad

New Member
Hello Everyone,
I was trying to extract shipment tracking data from the shipping line website. Shipment tracking IDs are available in column 1 of my file and I am trying to get data in the next columns. My tracking site is

Shipping Container Tracking and Tracing | MSC

MSC offers an online tracking and tracing system enabling containers to be tracked throughout the world. Find your freight fast. Contact our team today!
www.msc.com
I was trying to get help from another thread in this forum which is

Extract data from website

Hello There, I would like to know how can I extract website data using VBA. Currently the below manual procesure is followed. I would like to do this using excel VBA The following is the manual procedure followed: 1. Go to website: https://www.msc.com/nld 2. Click Tab "TRACK...
chandoo.org
But unfortunately, Internet Explorer is not working.

Is there any way of getting data dynamically in my Excel file?
Thanks to you all in advance for your support.

Regards
Shazzad
 
Last edited by a moderator:
This is a long shot: Can you get the data you want from the attached? If so what info do you need from it?
I suspect this data is dummy/demonstration data from their Developer Portal

EDI and API Shipment Management - Digital Solutions | MSC

MSC direct integration, EDI and API, solutions enable the safe and secure transfer of data from our system to yours with easy integration and use. Get a quote!
www.msc.com
so I suspect you might have to talk to them.
I got this from

API Catalogue

developerportal.msc.com
the first item DSCA Track and Trace
Enter a tracking number in cell A1, then right-click on the green table and choose Refresh?
 

Attachments

  • Chandoo55960.xlsx
    22.9 KB · Views: 23
Last edited:
Hi p45cal, Thanks for your support. I have checked your solution and the query you have created. but I am looking for the info as attached picture.
And one more thing is I need to track the details of several shipments in the same worksheet. 1706434472785.png
 
It's impossible for me to help you since I have no account, no login, to the site. Nor am I about to enter into a dialogue with their Development Portal people.
 
You must log in or register to reply here.
Back
Top