Excel VBA Introduction Part 57.5 - Implicit and Explicit Waits in Selenium

By Andrew Gould

Chapters
00:00 Topic List
00:41 The Basic Code
02:50 Identifying Elements
06:40 Failing to Find an Element
08:55 Checking if an Element is Present
10:48 Why the Delay?
11:48 Changing the Implicit Wait
12:39 Setting the Timeout Parameter
13:41 Capturing the Suggestions Element
16:42 Looping Through Suggestions
19:23 Race Conditions
20:42 Setting an Explicit Wait
23:38 Waiting for an Element to be Displayed
27:05 A Practical Example
28:41 Referencing the Tables
32:46 Writing the First Table to Excel
34:28 Clicking the Tomorrow Button
36:29 Using an Explicit Wait
38:52 Getting the Departures Table
41:59 Waiting for the Table to be Displayed
44:36 Getting Departures for Tomorrow

This video explains how to wait for elements on a web page using Selenium in Excel VBA. You'll learn how to check if an element is present, how to alter the implicit wait time of the web driver, how to use the timeout parameter of the FindElement methods and how to wait for an element to be displayed.

[natnaelayele]

I am from Ethiopia, Africa. I can't have words to thank you. You are an teacher

[oholiab-song]

Thank u from Korea. If u wrote a book, I definitely purchase one. It's the best ever lesson I have watched.

[axelamoe]

Thank you so much the driver.wait solved my problem. Thank you for your great videos

[bencole]

Thank you Andrew. I was utilising the previous lessons and came across the exact problems this video describes and once again thanks to your amazing tutorial skills I have been able to correct my generated errors. I seriously can’t thank you enough. Any tips on which Wise Owl tutorials I should move onto next as I’ve now completed the web scraping videos. I’m thinking about getting my teeth into SQL, so maybe I’ll watch those. Thank you once more and honestly your are my hero of the coding world. Brilliant absolutely brilliant. 6 out of 5 stars for the video content and delivery.

[josephdaquila]

Could this be used a solution to having a time out occur on the starting of the driver?

[harinandhu]

Hai
I'm using Excel VBA to automate data entry in chrome website.
The website to particular part will be type at manually.so i have information for I'm typing to manually the program will be wait then i will click button (id) or (xpath) to continue automation program

Please help for me

[KhalilYasser]

Awesome and amazing tutorials my tutor.

[jwchoi]

Great posting and you are indeed "Wise Owl". thanks a lot ...
By the way, I'd like to know the way to get 'Boolean' results when facing 'stale element reference error'. Then, I could code to repeat when stale error happen.

[tafa]

wait 100 I want it to repeat the wait time randomly in a time interval how should my line of code be ?

[markvalenzuela]

Hi Andrew! do you also have the How to download file in web and save in folder using selenium? Thanks for this tutorials!

[tmusic]

Thank you very much for your videos. I have a question: In ChromeDriver when downloading a ".xml" file, is it possible to disable "This type of file can harm your computer ..." pop-up ?

[mauricerobert]

Thank you Andrew for your videos ! In the part 'waiting for an element to be displayed', some other properties are shown (is enabled, is present, etc). In case I would want to use such property, that returns a boolean, in order to wait for the element to have the said property true, is there another than just using a do loop while coding ?

[harinandhu]

How to selenium chrome VBA automation wait the automation after click id or xpath to continue program

[IyilikKapsKonya]

Well, i want to this; untill i close Chrome, it run. Dont stop it. How can i do?

[RyneMauck]

Is there a way to write the table into an existing worksheet so a new sheet is not created each time?

[sidharthpattanayak]

In office 365 chrome browser is not opening while using selenium

[antoniomaestre]

Thanks millions for yours videos but unfortunately I'm not able to make implicit timeout work, nor using .Timeouts.ImplicitWait neither in a set statement, in fact in the 13:35 time stamp we can see it didn't worked for you to, can help me?

[victorrpf]

Thank you very much for your videos. Please, I have a question. Is it possible to implement in selenium webdriver an ERROR HANDLER like in VBA?

[thechameleon]

Hello, is there a way to wait for a webpage to fully load. For example, let's pretend the page is stuck in the loading phase, if the page is going to timeout selenium and throw an error in vba after a certain time, say 20 seconds, then vba and selenium will catch the error that is about to be thrown and try to reload the page at least 1 time?

[gauravchavan]

Is there a way to work on an already open chrome browser using VBA?