Channel: WiseOwlTutorials

Category: Education

Tags: web scrapingscraping websitesoption elementpick optionprint websitedrop listmicrosoftgoogle chromeselenium basiccopiesseleniumprint webpagechoose optionselect optionprint web pagechomedrop down listonline trainingselect elementfree trainingselect itempick itemdropdowndropdown listprintingprint previewexcelprintvbavisual basic for applicationspage orientationdrop down websiteexcel vbawise owlscrape website

Description: By Andrew Gould See more web-scraping videos here youtube.com/playlist?list=PLNIs-AWhQzcl3xKvF8sVL4sWRWICj_clM If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks: youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join Or you can click this link wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! This video explains how to print a web page in Google Chrome using VBA. You'll learn how to enable kiosk printing mode and send a keyboard shortcut to print a page immediately using your default print settings. You'll also learn how to access the print settings page and change options such as page orientation and number of copies. Chapters 00:00 Topic list 00:40 Sending a Keyboard Shortcut to Print 02:44 Selenium SendKeys 04:03 Printing the Page with Default Settings 05:37 Switching to the Print Preview Window 06:45 How the Print Window Elements are Organised 08:33 Accessing the Shadow Root of the Sidebar 11:49 Referencing the Layout Drop Down List 14:36 Selecting an Option from the Drop Down List 15:31 Finding and Clicking the Print Button 18:47 Referencing the Copies Input Element 24:06 Changing the Value of the Copies Element Visit wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!