+ Reply to Thread
Results 1 to 6 of 6

extract data from web to inside sheet like google drive without open website

  1. #1
    Forum Contributor
    Join Date
    06-17-2021
    Location
    Asia
    MS-Off Ver
    2019
    Posts
    219

    extract data from web to inside sheet like google drive without open website

    Hi experts
    I would extract specific data from this website https://www.cma-cgm.com/ebusiness/tracking to sheet without open web. so my idea is like google drive when search specific thing . when you open the website you will see place to put Container, Bill of lading or Booking reference so if it's right then will show the cargo when departure and when arrive to last port just scroll to down you will see detials .
    in the sheet I will use textbox1 to put Container, Bill of lading or Booking reference and then should import data from web to columns A,B,C,D,E as I put it into sheet
    so compare picture based on web when enter container no with my output in sheet
    by the way I also posted in this forum https://www.mrexcel.com/board/thread.../#post-5876767
    I no know if what I ask for it is impossible.
    I truly appreciate if any body help.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    06-17-2021
    Location
    Asia
    MS-Off Ver
    2019
    Posts
    219

    Re: extract data from web to inside sheet like google drive without open website

    can any body see my request, please?

  3. #3
    Forum Contributor
    Join Date
    02-25-2022
    Location
    Dallas, Texas
    MS-Off Ver
    Office 365
    Posts
    174

    Re: extract data from web to inside sheet like google drive without open website

    The company could offer a web API. You need to contact them to see if one is available. You could scrape web using SeleniumBasic/Chrome and you use headless mode so you don't see it.

  4. #4
    Forum Contributor
    Join Date
    06-17-2021
    Location
    Asia
    MS-Off Ver
    2019
    Posts
    219

    Re: extract data from web to inside sheet like google drive without open website

    Hi,
    thanks for your replying ! actually I search for macro does that . I see some codes in the internet extract the data , but my request is different I don't find like my request . now I knew why nobody gives me any solution , it seems extremely difficult.
    I hope the experts see my request soonly

  5. #5
    Forum Contributor
    Join Date
    06-17-2021
    Location
    Asia
    MS-Off Ver
    2019
    Posts
    219

    Re: extract data from web to inside sheet like google drive without open website

    it seems to be impossible by vba

  6. #6
    Forum Contributor
    Join Date
    06-17-2021
    Location
    Asia
    MS-Off Ver
    2019
    Posts
    219

    Re: extract data from web to inside sheet like google drive without open website

    it's solved

+ 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. How to retrieve a google drive url for a pdf file stored in google drive
    By SBEC in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-01-2021, 01:40 PM
  2. Google sheet: Help to attachment file from Google Drive and send email fill in Google Form
    By sbv1986 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 03-01-2021, 10:47 PM
  3. [SOLVED] Google sheets script to download file and save it to google drive folder and use it's data
    By western in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 5
    Last Post: 01-18-2021, 01:31 PM
  4. [SOLVED] Google sheets vba to download file and save it to google drive folder and use it's data
    By western in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-14-2021, 08:48 AM
  5. How Extract data from PC to a file in google drive?
    By Hussain Anees in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-29-2015, 08:58 AM
  6. Open a CHM or HLP file on a google drive from a vba routine.
    By crywolf in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-19-2015, 07:25 PM
  7. [SOLVED] Automatically open and close spreadsheets on Google drive
    By judy hess in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-22-2013, 03:35 PM

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