Скачать или смотреть Excel VBA Introduction Part 57.6 - Working with Multiple Tabs in Selenium

See more web scraping videos here    • Excel VBA Getting Data from Websites  

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1​ to make a donation. Thanks for watching!

Get files here https://www.wiseowl.co.uk/vba-macros/...

The video shows you how to open and work with multiple tabs in Google Chrome using Selenium Basic for VBA. You'll learn how to use the window.open javascript method, how to pass a URL into the method's parameter and how to switch to the tab that was opened. You'll also see how to open multiple tabs and loop through them to extract information before closing each one down. The final example in the video shows how to navigate to the Yahoo Finance website and extract a table of data for each date in a drop down list.

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

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more