Wise Owl Answers - How do I scroll down a web page in Chrome with Selenium for VBA?

By Andrew Gould

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:

This video shows you how to scroll down on a web page in Google Chrome using Selenium for VBA. You'll learn how to send keyboard shortcuts to your browser and how to execute javascript code to scroll a page.

Chapters
00:00 The Question
02:06 Using the Page Down Key to Scroll the Page
05:11 Executing Script to Scroll the Page
08:44 Scrolling Smoothly with the scrollBy Method
10:45 Scrolling to the Bottom of a Page
12:35 Scrolling in a Loop
14:18 Changing the Example
16:49 Scrolling Instantly to the Bottom of the Page
18:25 Scrolling Smoothly to the Bottom of the Page
19:39 Scrolling Down One Page
21:05 Writing the Table to Excel

[datagru]

This is outstanding, you are literally taking VBA to next level. I am pretty sure there is no one like you. Respect👏.

[fksoftware]

Thank God I've finally seen the genius behind all these helpful tutorials. Thank you Sir.

[KhalilYasser]

Thank you very much, my tutor. Really glad to see your face.

[rajeshmajumdar]

Thank you Andrew. It is one of my wish to see you. You are a great help for me.

[PankajNegi]

Hi Sir Great to See your face with awesome training session. Thank you very much I really enjoy.

[tejamarneni]

Thank you Andrew for the Awesome video. I'm really glad to see you. The intro is amazing.

[imranbhatti]

Great Andrew, I was waiting this series to continue as currently working on some selenium VBA tasks.

[afewthingsabouteverything]

Really appreciate this, thank you Andrew

[krn]

Thanks Andrew. Nice to finally put a face to the voice after all these years of listening to you. I for one know right away who from WiseOwl is speaking. Your voice is very distant in my ear. :)

[kartickchakraborty]

Finally, we've seen your face Sir. I'm very glad to see you for the first time. Take my gratitude, Sir. 🙏🙏🙏🙏

[tqlgrzw]

I am a beginner in coding, and my English is very poor.
But with the YouTube option subtitle + translation setting
After repeating the video you uploaded for about 2 hours, I understood it very well.
thank you so much. Thanks for the good knowledge.
I don't comment on videos from other countries, but thank you so much,
I like the study result, so I use Google Translate to leave a thank you comment.

[aarona]

I probably watch one of your videos once a month, back from the early days, even though I'm no longer in a role that requires heavy VBA knowledge. Your skillset keeps evolving.

[Praguedpaul]

Oh my gawd Mate - finally the face reveal after 7 years of watching your videos. As usual fantastic video.

[sureshmadha]

Great to see you...Respect from India..😊

[The_Code_Father]

your face got the video even brighter
good luck mr Andrew

[kumar-manoj]

Thank you so much sir, that was great...

[frikduplessis]

Thank you Andrew for a brilliant tutorial as always 👌 finely after so many years I saw the man behind the voice 👏👏 its a brilliant idea, hard luck to find the Twilight series on your bookshelf 😃

[RedCoat]

Thank you for all these. How do I mouse hover to navigate through dynamic menus?

[LegoAndPiano]

How can I scroll an already opened Chrome webpage? The opened page has extensions that I need like an add blocker, it has a user already logged in, etc that the same page opened via Selenium code does not have.

[mukeshexpo]

Thanks for having mentor like you I have learnt lot from you, one problem I am facing that how we can handle print button on any website because by using selenium as soon as I click the button print window open and VBA got freezes