I became a VBA developer just because of the way Andrew Gould designs the lecture..from Zero to Hero Thank you Andrew. Very happy to see your face for the first time
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. :)
I am a beginner in coding, and my English is very poor. But with the TH-cam 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.
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.
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 😃
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
Hi Mukesh! I'm sorry I don't have a good answer for that question off the top of my head. The question is on my To Do list and I hope to get time to look at it soon!
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.
Hi Simon, perhaps ClickAndHold is the answer stackoverflow.com/questions/54396990/how-to-mouse-over-an-web-element-to-see-a-list-of-hidden-option-then-process-to I hope it helps!
Hey Andrew, Thank you for the specific video on Scrollbar. Can u plz let us know as how to get the scrollHight or width? I tired alot on Google but nothing worked for me..plz assist
Hi Mohammad! We show how to refer to the scroll height in this same video. For the scroll width you can refer to this link developer.mozilla.org/en-US/docs/Web/API/Element/scrollWidth I hope it helps!
Hi Andrew, i took the lessons of the playlist and im so glad, i was able to automate many cases of getting data from websites. Now im wondering to get data from restaurants from any City in google maps, the stuff is that the scroll is so difficult that im not being able to pull all the results, instead i can only pull the first ones, it is posible for you to check it out??
Hi there, is there a way to know how many characters was manually typed in a certain field that doesn't have value attribute? I've got to routine that have been checking when user typed a captcha answer in a certain website but now they updated its website and removed value attribute of this field so I don't know when the user finished typing captcha value and automatically move to the next step.
Hi Rafael, I'm sorry I don't know the answer to that one. You may be able to do something with "Event Listeners" but it's not something that I have much experience with.
Thanks a lot for this wonderful video. I have tested this and scrolling is working fine for different websites. But window scrolling is not working for google maps. Is there any way to scroll on Google Maps website?
Hey WiseOwl - I have a webpage that requires a click on a pop-up window but I keep getting the 'element not interactable' error because the web driver can't click the button on the pop up window for whatever reason. The element has an ID and class, and neither findelementbyclass/ID works when it comes time to click the button. Would love to get some words of advice on this.
Hi! There could be several reasons for this, you can see some suggestions here stackoverflow.com/questions/45183797/element-not-interactable-exception-in-selenium-web-automation I hope it helps!
Hi Santhosh! I'm sorry I don't know the answer to this question. You may be able to do something with "Event Listeners" but I don't have much experience with that topic.
@@santhoshr6422 Hi Santhosh, Selenium doesn't support connecting to an existing browser - it's designed explicitly to open a new instance each time a test is run. Selenium Basic doesn't support FireFox at all any longer, sadly.
Just install the new version of the ChromeDriver - make sure you're using the major version number which corresponds to the version of Chrome you're running. I hope that helps!
Hi Alejandro! You can find me on LinkedIn www.linkedin.com/in/andrew-m-gould/ We also have an enquiry form on the Wise Owl website for business enquiries www.wiseowl.co.uk/
Andrew, thank you so much. Your vids are fantastic. A tutorial on how to write data from a table to Excel may be found in this video. Although the table you took spans 14 pages, you only recorded data on page 1. May I inquire as to how I can obtain all of the information from those 14 pages without having to open each one? Thank you kindly.
This is outstanding, you are literally taking VBA to next level. I am pretty sure there is no one like you. Respect👏.
Thank you Ravi, I appreciate the kind words!
I became a VBA developer just because of the way Andrew Gould designs the lecture..from Zero to Hero
Thank you Andrew. Very happy to see your face for the first time
Thank God I've finally seen the genius behind all these helpful tutorials. Thank you Sir.
😀 I'm very far from a genius but I appreciate the kind words, thank you!
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. :)
Thank you for all the views and comments over the years Kevin, it's all very much appreciated!
Finally, we've seen your face Sir. I'm very glad to see you for the first time. Take my gratitude, Sir. 🙏🙏🙏🙏
Thank you for the lovely comment Kartick!
I am a beginner in coding, and my English is very poor.
But with the TH-cam 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.
Thank you so much for taking the time to write such a nice comment!
Thank you Andrew. It is one of my wish to see you. You are a great help for me.
Thank you Rajesh, both for your kind comments and your generous support!
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.
Thanks Aaron, it's lovely to hear when people have stuck with us for a long time! I appreciate all the views and the comments, thank you!
Thank you very much, my tutor. Really glad to see your face.
Thank you Yasser for all your comments!
Great Andrew, I was waiting this series to continue as currently working on some selenium VBA tasks.
Thanks Imran, glad you enjoyed it!
Good to finally see you!
Thanks Noam!
Hi Sir Great to See your face with awesome training session. Thank you very much I really enjoy.
Thank you so much! I'm glad that you enjoyed the video and thank you for taking the time to write a comment!
Thank you Andrew for the Awesome video. I'm really glad to see you. The intro is amazing.
Thank you Ravi, my pleasure as always!
Oh my gawd Mate - finally the face reveal after 7 years of watching your videos. As usual fantastic video.
😀 a pleasure as always, hope the face wasn't too shocking!
Great to see you...Respect from India..😊
Thank you Suresh!
Really appreciate this, thank you Andrew
You're welcome thanks for watching!
your face got the video even brighter
good luck mr Andrew
Thank you for the lovely comment and for watching!
Very helpful, Thank You so much
You're welcome, thank you for watching!
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 😃
😀 cheers Frik! I made sure I removed the "I ❤ Edward" poster before recording the video.
@@WiseOwlTutorials 🤭 it is really awesome putting a face to the voice 😃👍
@@frikduplessis8849 Thanks Frik, I'm glad you approve and thank you for the support!
Wow you are looking very smart.
😀 thank you!
Great ! thank you so much! Respect
You're very welcome, thanks for watching!
Thank you so much sir, that was great...
My pleasure Manoj, thanks for watching!
You are great. 👍
Thank you! 😀
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
Hi Mukesh! I'm sorry I don't have a good answer for that question off the top of my head. The question is on my To Do list and I hope to get time to look at it soon!
Hi Mukesh, you might find the latest video useful th-cam.com/video/jEYvgU46gmE/w-d-xo.html
I hope it helps!
@@WiseOwlTutorials thank you sir, yes this video has resolved my problem. Once again thanks from my bottom of the heart. 🙏🙏🙏🙏🙏🙏
@@mukeshexpo My pleasure Mukesh, I'm happy that it helped!
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.
You can't I'm afraid - SeleniumBasic only works when opening a new browser instance.
can you give a idea of google map result scroll in VBA?
Thank you for all these. How do I mouse hover to navigate through dynamic menus?
Hi Simon, perhaps ClickAndHold is the answer stackoverflow.com/questions/54396990/how-to-mouse-over-an-web-element-to-see-a-list-of-hidden-option-then-process-to
I hope it helps!
Hey Andrew,
Thank you for the specific video on Scrollbar.
Can u plz let us know as how to get the scrollHight or width?
I tired alot on Google but nothing worked for me..plz assist
Hi Mohammad! We show how to refer to the scroll height in this same video. For the scroll width you can refer to this link developer.mozilla.org/en-US/docs/Web/API/Element/scrollWidth
I hope it helps!
Hi Andrew, i took the lessons of the playlist and im so glad, i was able to automate many cases of getting data from websites. Now im wondering to get data from restaurants from any City in google maps, the stuff is that the scroll is so difficult that im not being able to pull all the results, instead i can only pull the first ones, it is posible for you to check it out??
Sounds like an interesting problem! I'll see if I have time to look into it (no promises though!). Thanks for watching!
Hi there, is there a way to know how many characters was manually typed in a certain field that doesn't have value attribute? I've got to routine that have been checking when user typed a captcha answer in a certain website but now they updated its website and removed value attribute of this field so I don't know when the user finished typing captcha value and automatically move to the next step.
Hi Rafael, I'm sorry I don't know the answer to that one. You may be able to do something with "Event Listeners" but it's not something that I have much experience with.
Thanks a lot for this wonderful video. I have tested this and scrolling is working fine for different websites. But window scrolling is not working for google maps. Is there any way to scroll on Google Maps website?
Hi! Sorry I don't know the answer to that one!
Hey WiseOwl - I have a webpage that requires a click on a pop-up window but I keep getting the 'element not interactable' error because the web driver can't click the button on the pop up window for whatever reason. The element has an ID and class, and neither findelementbyclass/ID works when it comes time to click the button. Would love to get some words of advice on this.
Hi! There could be several reasons for this, you can see some suggestions here stackoverflow.com/questions/45183797/element-not-interactable-exception-in-selenium-web-automation
I hope it helps!
@@WiseOwlTutorials Found in one of your videos how to use xpath and that made it work. Thanks so much!
@@userone8545 Happy to hear you found an answer!
Hai sir
If element Class is continuously changing. Like events
That time how to click particulars elements class
Hi Santhosh! I'm sorry I don't know the answer to this question. You may be able to do something with "Event Listeners" but I don't have much experience with that topic.
I need answers for one more question
My questions is how to scrapping or set values already opened Firefox tab using excel vba and selenium
@@santhoshr6422 Hi Santhosh, Selenium doesn't support connecting to an existing browser - it's designed explicitly to open a new instance each time a test is run. Selenium Basic doesn't support FireFox at all any longer, sadly.
New version chrome not supported selenium what to do ?
Just install the new version of the ChromeDriver - make sure you're using the major version number which corresponds to the version of Chrome you're running.
I hope that helps!
@@WiseOwlTutorials I will try. It is working or not
I am try firefox version 48. It not working
@@WiseOwlTutorials run time error 21
Timeouterror
The driver failed to open the listening port 127.0.0 with in 10 s
Please help me
I need to download images from whatsapp group sent by specific person starting from 1-1-2022
Waiting for your answer
Sorry I don't know!
how to scroll down in instagram box using vba ?
Sorry, I don't know.
Hi Andrew, any email address I can use to write you??
Hi Alejandro! You can find me on LinkedIn www.linkedin.com/in/andrew-m-gould/
We also have an enquiry form on the Wise Owl website for business enquiries www.wiseowl.co.uk/
Andrew, thank you so much.
Your vids are fantastic.
A tutorial on how to write data from a table to Excel may be found in this video.
Although the table you took spans 14 pages, you only recorded data on page 1.
May I inquire as to how I can obtain all of the information from those 14 pages without having to open each one?
Thank you kindly.
Wow. I thought you would have been much much older....
:D thanks Jack
Hi there
Hi!
@@WiseOwlTutorials Love your training series and your British accent.Thanks for sharing Andy
@@limichael1519 Thank you for the kind words and for watching!