+ Reply to Thread
Results 1 to 5 of 5

Using vba to scrape website where the data takes time to load

  1. #1
    Registered User
    Join Date
    07-07-2022
    Location
    Bay Area
    MS-Off Ver
    MS Office 2019
    Posts
    3

    Using vba to scrape website where the data takes time to load

    So I would like to use Bing to search UPS tracking numbers, and I have a long list of them, so I would like a vba solution that can do it all at once. My issue is the result I am getting is "Contacting UPS..." instead of the delivery date, which is the InnerText that Bing uses while it is loading the UPS delivery date. Is there a way to delay assigning the HTML document until after the website has fully loaded? I tried Application.Wait, which does not work.

    Screenshot 2022-08-23 152721.png

    Screenshot 2022-08-23 152844.png

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Using vba to scrape website where the data takes time to load

    when you say Application.wait didnt work, what value did you use?

    Have you tried a really big value in there (a couple of mins say) to be sure?
    If someone has helped you then please add to their Reputation

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

    Arrow Re: Using vba to scrape website where the data takes time to load


    As this code just reads how is the webpage at its opening before any data loading so you must pilot IE in order to get the expected result ...

  4. #4
    Registered User
    Join Date
    07-07-2022
    Location
    Bay Area
    MS-Off Ver
    MS Office 2019
    Posts
    3
    Using .navigate instead of .Open and .send did the trick. Thank you!

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

    Re: Using vba to scrape website where the data takes time to load


    Thanks to post your final VBA procedure, it may help other ...

+ 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. Scrape Data from Website by pasting URL
    By ogatland in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-07-2020, 05:40 AM
  2. [SOLVED] VBA scrape data from website HTML
    By Strutland in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-11-2017, 06:18 PM
  3. Logon daily to website, Scrape data, and paste into Excel 2003 Using VBA
    By Gloopie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-28-2014, 09:25 AM
  4. Scrape, pull or get data from a Website into Excel Please help me out
    By baig123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2014, 01:42 PM
  5. [SOLVED] Pull Specific Data from Website (Screen Scrape)
    By CHRISEWRIGHT20 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-11-2012, 11:03 AM
  6. VBA to scrape data from website
    By jdub22cb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-16-2012, 04:00 PM
  7. Excel Help takes a very long time to load
    By Sam Pack via OfficeKB.com in forum Excel General
    Replies: 4
    Last Post: 03-03-2006, 08:10 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