+ Reply to Thread
Results 1 to 7 of 7

Web Scraping - Container Tracking from Searates Website to Excel

  1. #1
    Registered User
    Join Date
    10-12-2018
    Location
    Vietnam
    MS-Off Ver
    2010
    Posts
    8

    Web Scraping - Container Tracking from Searates Website to Excel

    Hi everyone,

    As lacking of essential IT knowledge, I am looking for your kind help to make codes for getting data (final destination & ETA estimated time of arrival) from website tracking container numbers SEARATES to Excel.

    I have tried method of using GetElementbyID using IE Internet Explorer but this website browser is seems obsolete and useless.

    This SERATES website offer API information but it is too complicated for me to understand. I am enclosing container tracking list for your testing.

    Hope someone could give me support on this project which is important for my job of logistics.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow Re: Web Scraping - Container Tracking from Searates Website to Excel


    Hi !

    Quote Originally Posted by randaubienghoc View Post
    I have tried method of using GetElementbyID using IE Internet Explorer but this website browser is seems obsolete and useless.
    Wrong ‼ In particular for Excel / Web beginners when other ways are too difficult to understand …

  3. #3
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Web Scraping - Container Tracking from Searates Website to Excel

    (Removed, cross posting link below)
    Last edited by Marc L; 05-21-2021 at 05:48 AM.

  4. #4
    Registered User
    Join Date
    10-12-2018
    Location
    Vietnam
    MS-Off Ver
    2010
    Posts
    8

    Re: Web Scraping - Container Tracking from Searates Website to Excel

    Sorry for not mentioning link for cross-posting website. Herein the link:
    www mrexcel com/board/threads/web-scraping-container-tracking-from-searates-website-to-excel.1171480/
    I hope receive your help.

  5. #5
    Registered User
    Join Date
    10-12-2018
    Location
    Vietnam
    MS-Off Ver
    2010
    Posts
    8

    Re: Web Scraping - Container Tracking from Searates Website to Excel

    Anyone? I am expecting your kind help on this issue. Thanks. Maybe some advices?

  6. #6
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow Re: Web Scraping - Container Tracking from Searates Website to Excel


    As you wrote

    Quote Originally Posted by randaubienghoc View Post
    I have tried method of using GetElementbyID using IE Internet Explorer
    so if it really can't work under IE so it can't work neither under another way under VBA !
    If at least you have posted the VBA procedure you have attempted …


    Quote Originally Posted by randaubienghoc View Post
    This SERATES website offer API information
    Any link ?!

  7. #7
    Registered User
    Join Date
    10-12-2018
    Location
    Vietnam
    MS-Off Ver
    2010
    Posts
    8

    Re: Web Scraping - Container Tracking from Searates Website to Excel

    www searates com/reference/documentation-for-api-tracking-system/

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 8
    Last Post: 03-24-2021, 05:47 AM
  2. Scraping data from this website in excel
    By dorabajji in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-17-2019, 04:59 PM
  3. Web Scraping from Particular Website
    By Manikandan Arumugam in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-24-2017, 06:51 AM
  4. Automated data scraping from website into excel
    By kavin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-10-2014, 01:42 PM
  5. Scraping website into excel
    By eodsolo in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-12-2014, 06:25 AM
  6. Replies: 1
    Last Post: 02-17-2014, 11:21 PM
  7. Scraping website data into Excel
    By oliver79 in forum Excel General
    Replies: 0
    Last Post: 06-13-2010, 02:15 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1