Excel VBA Introduction Part 57.6 - Working with Multiple Tabs in Selenium

Chapters
00:00 Topic List
00:44 Opening Google Chrome
02:18 Opening a New Tab and Navigating to a URL
03:31 Parameterising the Script
04:39 Switching to the Next Window
06:47 Closing a Tab and Switching Windows
08:49 Looping Through the Windows Collection
10:38 Returning a Collection of Elements
13:03 Returning the href from a Link
14:56 Following Links in the Same Tab
17:06 Stale Element Reference Errors
17:55 Opening Multiple Tabs and Looping Through Them
20:09 Looping Through All Windows
20:44 Excluding the First Window from the Loop
21:57 Opening One Window at a Time
23:25 Navigating to Yahoo Finance
26:51 Referring to Options in a Drop Down List
28:59 Building a List of URLs
30:32 Opening Each Link in a New Tab
31:42 Writing Tables to a New Worksheet
36:09 The End Result

[dogbreath]

I thought I was pretty good at Excel VBA until I watched some of your videos. Holy cow, there is so much more potential here than I thought. Thank you for opening my eyes. Also, your teaching style is great---step by step, leading us to ideas, then showing why one way doesn't work and what can do

[janezklun]

Nicely explained tutorial, the best vba channel. Thank you Andrew

[TaskSwitcherify]

Awesome video in a very nice and useful series. We just need to get Basic Selenium for VBA updated. It's so old.

[krn]

Thanks Andrew. Let’s get Andrew 100 million more subscribers so he can go to space on holiday.

[naiduvikas]

Extraordinary stuffs ❤️ 😊😊
From India

[efernandes]

Great tutorial Andrew as always. Thanks.

[fauzipojie]

Nice sir..thx a lot..been waiting for this multiple tabs selenium

[tejamarneni]

Thank you Andrew for Amazing video as usual.

[tailethanh]

thank you so much for the great videos

[veronicacarabalmontagud]

The videos are so useful!! Thanks a lot!! Do you know if it is possible manage a iframe from selenium? I am trying it with switchtoframe but I always get an error...

[brayanangelpalmafrias]

Hi, I really appreciate your video, although it's hard for me to watch it because I have to use a translator because I don't know English, and in Spanish you don't get much information about selenium with excel, I have a query, is it possible to manage a page that is already open, that is, that the code does not open a browser for me to control it, rather, that it controls the browser with the page that is already open, thanks in advance, greetings

[syamanmon]

Just the kind of tutorial I needed! Just wondering, it is possible to switch to desired child tab from multiple tabs? My work requires switching from parent tab to child tab and then to parent tab again. the child tab will increase in number after clicking on the link from parent tab (the previous opened tab will stay open)

[kabukijoe]

hi. is there any way to save an opened webpage?

[potmmy]

Hi Andrew, thanks for great video as always. Is there possible to hide "Chrome is being controled by automated software?

[amarmendane]

Hi Andrew, First i really thanks for share! My question is... its there possible to open "chrome" another opened chrome instance?

[flavio]

Nice, next time can you make a video on how to move data from excel to chrome? for example a table and make a loop

[MohammadAli-tsev]

Thank you Andrew for this informative video.

Plz let me know the code to activate the window with Selenium/VBA

I have started a chrome window and did some activities on went to excel sheet for some calculation. Now I want to activate the window to take screenshot but i am not able to "activate".

cd.window.activate is not working
Any help would to fix this would finalise my project

[heinzaigner]

Hello,
.activate does not work on the curent chrome browser and selenium.
.close leads to a loss of the driver connetion, which makes ist also not usefull.
Can you reproduce that?

[lautarob]

Hello Andy. Again, thanks for your generosity in sharing your knowledge. Instead of creating a new instance of the browser, it is possible to jump into an existing browser session and start controlling it using Selenium?

[The_Code_Father]

Hi Mr Andrew sorry for being a headache but i was wondering if there is anyway that i can at the beginning of code check if there is an opened instance of browser I'm want to work with ( let's say chrome for example )
Can i do this so that i dun have to open a new instance each time i run the code