Excel VBA Introduction Part 57.1 - Getting Started with Selenium Basic and Google Chrome

[@dom6070]

Excellent starting point. Andrew, your pace and clarity are spot on.

[@WiseOwlTutorials]

Cheers Dom, glad you found it useful!

[@tarekyeh6245]

Thank you, I've been watching your videos for years now , I really appreciate your efforts and dedication to VBA ...if you ever deiced to visit Egypt, you got your self a free tour guide, Thanks again ❤

[@WiseOwlTutorials]

Thank you Tarek, that's a lovely gesture, I sincerely appreciate it!

[@blakepeterson1977]

FYI - I was able to overcome the Chromedriver version error by saving the downloaded version, per the error message, to C:\Users\(username)\AppData\Local\Selenium Basic\Chromedriver.exe. I tried various other solutions to no avail. Thanks for a great video! I'm overdue updating my Internet Explorer web scrapers. This is a big help.

[@WiseOwlTutorials]

Happy to hear that you solved it Blake, thanks for taking the time to share your solution!

[@lequimrp]

Excellent introduction to scraping with vba. I'm used to program in vba, but I've never used scraping. Nice explanations. Thanks a lot.

[@WiseOwlTutorials]

Thanks! Happy to hear you found it useful, thanks for watching!

[@derrellrose7020]

How did you find the webdriver?

[@lequimrp]

​@@derrellrose7020 I'm sorry, but I'm not an expert and I prefer to decline this answer in favor of people more trained on the subject.

[@WiseOwlTutorials]

@@derrellrose7020 Hi! You can get them from here googlechromelabs.github.io/chrome-for-testing/ I hope it helps!

[@abdullahquhtani4247]

Where were you MAN?! 😡 We really missed your amazing videos.

[@WiseOwlTutorials]

Thanks Abdullah, happy to see that you're still here!

[@tallcypress]

Saving my life. I've been using AutoIt and VBA but AutoIt is more built around IE. Excited to find this and finally start tackling chrome scraping. Thanks for this.

[@WiseOwlTutorials]

My pleasure, I hope it helps. Have fun!

[@enrikekasijas705]

I missed you ! Amazing tutorials! Thanks to your vids I really improved my vba skills which I didn't have before! You are the best tutor there is and will be. I only regret I didn't find you earlier!

[@WiseOwlTutorials]

Thanks Enrike!

[@CasparusBadenhorst]

Thank you for this and all the other high quality VBA tutorials.

[@WiseOwlTutorials]

You're welcome, Casper. Thank you for the comment and for watching!

[@FastingDude]

This is amazing, thank you very much! Excel is highly used in corporate that running it in workbooks save so much time in automating stuff. Thanks a million again! You’re the best, you’re the last boss in legendary mode that can’t be defeated.

[@WiseOwlTutorials]

😀 thank you Coro!

[@phana0071]

Fantastic tutorial. Thank you

[@WiseOwlTutorials]

You're welcome, thanks for watching!

[@rororara20]

Welcome back! We all miss your unique and simple way

[@WiseOwlTutorials]

If there's one thing upon which we can all agree it's that I am, indeed, simple!

[@Fly0High]

Just realised you've released a new bunch of tutorials. Quite amazing how quick you've been replying to our doubts and help find solutions. Thank you, really.

[@WiseOwlTutorials]

You're very welcome, thank you for watching and taking the time to leave a comment!

[@setukansara]

Another great video Andrew. Can’t wait to see 57.2. Learned a lot from you and still enjoy learning. Thank you.

[@WiseOwlTutorials]

Thanks Setu! Happy to hear you enjoyed it and thank you for taking the time to leave a comment!

[@johnhunter9747]

Andrew, you are a legend with these videos/tutorials. I have been working my way through your videos and no matter how many times I watch the same video again and again I still learn more stuff. I have been looking for a simple explanation for a while about controlling web browers that are not ie and just realised that you only just released this. Fully agree with Enrike's comment. Big thumps up mate.

[@WiseOwlTutorials]

Thanks John, really appreciate that!

[@dukestt5436]

Welcome back, great to see you again.

[@WiseOwlTutorials]

Thank you! Nice to see some familiar names.

[@edrobinson8248]

Breathtakingly brilliant

[@WiseOwlTutorials]

Ah thanks Ed, glad you enjoyed it!

[@nwengert]

Andrew, thank you so much for this series! PS, you should be the voice for meditation soundtracks.

[@WiseOwlTutorials]

You're welcome Nathan! Wait, are you saying my voice sends you to sleep?!

[@vh8000]

One of the youtubers that I will click 👍 before watching the video

[@WiseOwlTutorials]

Thanks Vincent! Nice to see some familiar names are still here!

[@scotolivera8207]

God bless you and thank you for your efforts

[@WiseOwlTutorials]

Thank you Gyan!

[@KhalilYasser]

Welcome back. Thanks a lot for this series.

[@WiseOwlTutorials]

You're very welcome, Yasser. It's nice to see some familiar faces are still here!

[@argonaut119]

Great job! I have researched this stuff for days and yours (my good man) is one of the best! You perhaps should replace Boris's new replacement as PM! LOL. Very very nice job. I am trying to do some basic web scraping but I must use my Mac (running Ventura) and also must web scrape from Excel VBA (no Python!). Excel is from Microsoft 365 (for Mac). Everyone else does it the easier way programmatically (i.e. from a PC Windows). Not a single video or website clearly shows HOW to do this using objects inside Excel VBA on a Mac (no reference libraries for HTML or other Controls). One Professor teaching a class on Scraping mentions that it is possible to create a Safari object easily on Excel VBA on Mac, BUT BUT I did not see how this instructor actually showed HOW on a video or outlined the steps. As they say where I am ( here in New York), "Talk is Cheap". The real issue may be due to Apple's Sandbox security. OODA all the way, so I need an Object inside of VBA (object for Safari, Chrome, or even IE). So I am still searching. Any guidance? ideas? thoughts? advice? Just love your instruction. Plan to contribute to you soon, my good fellow across the pond :).

[@WiseOwlTutorials]

Thanks so much, I'm happy to hear that you've found it useful! Sadly, I have zero experience with Excel for Mac and I wouldn't know where to begin. A quick Google suggests that MacScript might be a starting point to open a URL (but it doesn't provide much of a clue on how to control the browser once it's open) www.officeonemac.com/vba/open_url.html forum.ozgrid.com/forum/index.php?thread/107972-accessing-web-page-via-safari-on-mac-using-vba/ And thanks for the vote of confidence! While I agree that it would be difficult to mess things up more than the recent parade of PMs have, I don't think that I'm qualified to fix it!

[@nwengert]

I love you Andrew Gould

[@WiseOwlTutorials]

:D thanks Nathan!

[@terahhardin303]

Can you make an updated version of this video? I tried using the updated links found online, but I'm unable to get anything to work

[@WiseOwlTutorials]

Here you go! kzbin.info/www/bejne/gl7XqpxrjJJ-d68feature=shared

[@AmitSharma-po1zb]

Thanks a ton Andrew for another great share from your end...keep rocking always..pls dont let us miss u..😉

[@WiseOwlTutorials]

Thanks so much Amit! Great to see a familiar face!

[@AmitSharma-po1zb]

Same here Andrew...received notification of your new video ..haven't viewed it yet but I'm sure it will definitely be a great video again..😊👍

[@WiseOwlTutorials]

@@AmitSharma-po1zb Thank you!

[@LaloSalinas]

Amazing videos! Thank you for all the information. I have a question. Is it possible to use Selenium without install the library? (for other users) My idea is to use for different users, and it could be complicated that all the users install Selenium. Do you have any idea? Thank you!

[@WiseOwlTutorials]

Hi Eduardo! No, your users will need to have Selenium installed to run your code.

[@Damned943]

Thanks for another useful VBA tutorial!

[@WiseOwlTutorials]

You're very welcome, thanks for watching!

[@KLiCuk1]

Great stuff - looking forward to the rest of the vids in the playlist 👍

[@WiseOwlTutorials]

Thanks for the comment!

[@malcolmsokol4294]

Just came across this video and followed instructions to install and test Selenium. Okay unitl I ran the subroutine and the code for Set MyBrowser = New Selenium.ChromeDriver fails with runtime error with large numerical reference of 80131700 saying automation error. I have 64 bit windows 11 and am using MS office 365. Chrome version is 107 and that was the driver I installed. Nothing worked until I viewed some comments posted on the web somewhere that the problem was fixed by running StartChrome.VBS in the Selenium Scripts folder. This detected that MS Net Framework 3.5 was not installed and after running the scripts, it worked without having to change any VBA references. By installing compact Selenium as you suggested this dependency may not have been included and perhaps things changed since this video was created 5 years ago. (although the comment may have been written in 2015.)

[@pbassociates9168]

Very informative tutorial to accelerate automation using VBA. It is requested to share your great knowledge about using Win Api in excel VBA. Thank you in advance

[@曾忠凱]

Thank you Andrew! Very helpful videos!

[@WiseOwlTutorials]

You're welcome, thanks for watching!

[@hericklenin]

Como siempre, el mejor canal de VBA. Gracias por tan buen contenido.

[@WiseOwlTutorials]

Muchas gracias , Herick!

[@vallorahn]

I just needed to make some exports from sales systems, already wrote some Autohotkey for it, but that seems much much more useful. Thanks!

[@WiseOwlTutorials]

You're very welcome!

[@ВячеславАнтонов-п3в]

Best lessons vba, thanks autor!

[@WiseOwlTutorials]

Thank you for the kind comment!

[@manndipp]

can't thank you enough, you are GOAT VBA youtuber

[@WiseOwlTutorials]

Thanks so much for watching!

[@krn14242]

Welcome back Andy. Missed ya.

[@WiseOwlTutorials]

Thanks Kevin!

[@oliviercadier5345]

Thank you for this very useful step by step video. Exactly what I needed.

[@WiseOwlTutorials]

You're very welcome Olivier, happy to hear that you found it useful! Thanks for watching and for taking the time to leave a comment!

[@MyAudioBookCompilation]

Still the best mentor! 😁 I owe everything to you sir.

[@WiseOwlTutorials]

😀 thanks!

[@MyAudioBookCompilation]

@@WiseOwlTutorials Hi again, it's been 3 years. Is there a way sir to remove the 'Chrome is being controlled by automated test software."? Because this prevents me from signing in to my account. Thanks in advance sir.

[@WiseOwlTutorials]

@@MyAudioBookCompilation Hi! I don't know of a way to do this, sorry.

[@MyAudioBookCompilation]

@@WiseOwlTutorials No problem sir. Thank you.

[@charlesajouri7233]

Great start for 2021! Thanks.

[@WiseOwlTutorials]

Thanks Charles!

[@jessipinkman7659]

You are true guru

[@WiseOwlTutorials]

Thank you!

[@kartickchakraborty9135]

Your videos are always helpful for learner like us. Sir, my request to you, please upload a complete tutorial on VBA Regular Expressions. I can't understand it properly from reading my book. It's really hard for me to understand this topic.

[@learnwithfun567]

Excellent tutorials. Its a value addition to youtube

[@WiseOwlTutorials]

Thank you!

[@tg5441]

Thanks for the upload. Miss you so much

[@WiseOwlTutorials]

You're very welcome! Thanks for watching and for the comment!

[@tg5441]

@@WiseOwlTutorials By the way, I encounter Automation error when I try out your code. After searching it needs .Net framework 3.5 to run. Now it is working

[@WiseOwlTutorials]

@@tg5441 A good tip, thanks for sharing!

[@tg5441]

@@WiseOwlTutorials You are welcome. I have learned a lot from you

[@KumarAnalytic]

Great Lecute sir

[@WiseOwlTutorials]

Thanks!

[@rolandtobiasz]

Thank you! I think that this is the first video that I've watched that no idiot gave a thumbs down so far for such a helpful content (5095 views 03/13)!

[@WiseOwlTutorials]

Thanks Roland! I would give myself a thumbs down because I didn't include the advice to ensure that the .NET Framework 3.5 was installed on Windows 10! I've added a note and a download link for this to the video description now but it's still a shocking oversight on my part :D

[@rolandtobiasz]

@@WiseOwlTutorials I didn't even notice it. I must have installed it sometime in the past because following your instructions, I was able to fire up Selenium, which I'm trying to get my head around on selections and clicks. Baby steps so far, but thank you for the videos!

[@WiseOwlTutorials]

@@rolandtobiasz I believe that it's installed automatically with other software such as Visual Studio which is why I didn't notice it either! Happy to hear that you're enjoying the videos, thanks for watching!

[@Jwichern01]

Fantastic series! I ran into an interesting install issue. If I install normally it defaults to the AppData folder location and everything works fine. However, if I install as an Admin, which is my company’s policy, it defaults the install directory to “program files” folder location. In Excel I am still able to create a reference to selenium but now when I run my code it crashes when the” new selenium.chromedriver “ code activates with an automation error. Error states “%1 is not a valid Win32 application”. Any idea why installing to the program files location would create this error? Note - Same chromedriver is used in both scenarios.

[@WiseOwlTutorials]

Thanks John! Agreed, that is an interesting issue. Sadly, I don't know why it would happen or how to solve it! While the course code for SeleniumBasic is available on Github I think it might be easier to convince IT to allow you to install it so that it works. Sorry I can't help with this one!

[@81flame]

You are perfect man. I want to say you "very very very very ... thank you" 😇😇😇😇

[@WiseOwlTutorials]

You're very very welcome! Thank you for watching!

[@81flame]

@@WiseOwlTutorials I have forgetten to subscribe to your channel. I have done just now😇

[@WiseOwlTutorials]

@@81flame Thank you!

[@janezklun]

Thank you for sharing your skills, knowledge, mehods, the best on net, Cheers

[@WiseOwlTutorials]

Thank you Janez, I appreciate the comments!

[@rodrigoordenes4858]

I need to ask you another question. When I press a link on a page I'm browsing, it opens a new page. How can you know the url of the page that was opened? and How can you know the number of pages that are open? Thank you.

[@WiseOwlTutorials]

Hi Rodrigo! Try video 57.6 in this playlist kzbin.info/aero/PLNIs-AWhQzcl3xKvF8sVL4sWRWICj_clM I hope it helps!

[@johnmaguire2185]

Welcome back.

[@WiseOwlTutorials]

Thanks John

[@benediktusdanangsatria4967]

I do love your video!! It helps me a lot!

[@WiseOwlTutorials]

Happy to hear that, thanks for watching!

[@mwewachisenga9179]

Hello I have been following your videos on web scrapping and they have really helped improve my VBA Skills. I have a couple of questions though; 1. Is it possible to scrap any regular data ( a part form data which is in a table ) from a website to an excel work sheet ? If Yes how can it be done ? 2. Is it possible to refresh the scraped data (so as to get fresh new data) on an excel worksheet using the same module (which scrapes data from any website) by a click of a button ? If yes how can it be done ?

[@josephdaquila2479]

I would analyze the structure of the website you are trying to pull data from to see where in that webpage your data exists. Start with right clicking in your browsing and pressing "Inspect" to see the elements that make up any webpage. In terms of doing it at a click of a button you can write it as a macro (subroutine) and assign it to the click of a button that you inserted into Excel.

[@RaMeShBaBu-gf1wc]

I have tried it's working perfectly but chrome library 97 version need to take for my system. Nice information nice explanation. Thank you Sir

[@WiseOwlTutorials]

Thanks! Yes, Chrome updates itself automatically so you'll need to download the new ChromeDriver when this happens.

[@PankajNegi007]

Great Andrew sir

[@WiseOwlTutorials]

Thank you Pankaj!

[@ma.laurafndez2551]

Excellent video! i appreciate it!

[@WiseOwlTutorials]

Thank you!

[@juanpablohorn6642]

I just finished the whole VBA Introduction playlist last week! Just in time to be up to date with this new video! Great work Andrew! I tried running the code and found out that for me the code opens two tabs on Chrome. One for the Wise Owl website, and the other one that says data:, . Would you happen to know what causes this issue? Also worth mentioning, when Google Chrome opens a pop-up window for an anti-virus that disappears within a second. Is there a way to prevent this?

[@WiseOwlTutorials]

Perfect timing! Hope you enjoy the new videos. I'm not certain why you're seeing two tabs opening. Do you have Chrome set to open multiple tabs on startup in Settings? We can definitely deal with pop-ups using Selenium - it's on my list of things to cover in this playlist!

[@juanpablohorn6642]

@@WiseOwlTutorials I do have a couple of starting tabs on my Chrome. Maybe that is the reason. Great! I'll be looking forward to your coming videos! Edit: I tried changing the setting so chrome opens on a new tab page and it still shows the data:, tab. So there might be something else causing this problem.

[@albertobarahona]

thank you for this tutorial, Might want to review and update the chrome driver site as it is changing soon

[@WiseOwlTutorials]

Thanks Alberto!

[@yassenyassen5840]

لايمكن المرور من هنا دون الضغط على الاعجاب. شكرا استاذ .

[@WiseOwlTutorials]

مرحبا بك

[@kashifkhanspecial]

Hi Andrew, thank you so much for your time & efforts for this video tutorial, really appreciate it, I have one question and I want your help on this, suppose I have chrome 90 version and I installed Chrome driver for version 90 on my system and developed a VBA tool for web scraping with Chrome driver version 90, now when I distribute this VBA tool to my client/end user, however end user have Chrome 87 version, will my VBA tool work for end user? because he has lesser version then my Chrome driver version, if not what is the solution? and how can we deal such kind of problem, can we develop a tool which can work on any Chrome version?, can we use Late binding method here? Thanks in advance for your support. Take care and stay safe. Thanks Kashif

[@WiseOwlTutorials]

Hi Kashif! As long as your end user has the correct Chrome driver installed for the version of Chrome that they are using then your code will still work (providing that they also have the SeleniumBasic library installed of course!). Your VBA project doesn't reference the Chrome driver directly - it references the SeleniumBasic library. I hope that helps and thank you for your support!

[@kashifkhanspecial]

Thanks Andrew! For the reply you cleared my doubts, thanks again. Take care. Thanks Kashif

[@WiseOwlTutorials]

@@kashifkhanspecial My pleasure Kashif!

[@jimhubbard7075]

Google is constantly forcing Chrome to update. When I downloaded the Selenium webdriver, I assumed that I had the latest verison of Chrome so I downloaded the latest Selenium driver. When I tried to run the simple MyBrowser.Start example I saw the browser flash on then off and I got a runtime error '33' which says in part "session not created: This version of ChromeDriver only supports Chrome version 95 Current browser version is 94.0.4606.71 with binary path...." So, my concern would be that any code will break when Google next updates Chrome unless you always remember to update the Selenium Webdriver at the same time.

[@WiseOwlTutorials]

Hi Jim! Indeed, sadly this is just how it is with the SeleniumBasic library. The project author hasn't updated it in several years so I imagine this is how things will remain unfortunately.

[@jessipinkman7659]

Dear Sir, Can we connect html table to ms access database.

[@naiduvikas202]

Your tutorial crazy man. Come to India 🇮🇳 we will build a temple for you

[@Yorumcu63]

Wow Great Tutorial .Thank you

[@WiseOwlTutorials]

You're very welcome, glad you found it useful and thanks for taking the time to leave a comment!

[@AshwiniRaut-b1c]

bhari , kadak

[@cecewang70]

i have got run time error in my workplace PC. Is it because the chromedriver is not permitted to run when I clicked it?

[@kjesu2715]

Perfect tutor...

[@WiseOwlTutorials]

Thank you!

[@Keana6]

Question: What is Selenium used for? Does the target pc have to have that installed ?

[@WiseOwlTutorials]

Hi! It's used to automate web browsers and yes, the target machine needs to have it installed.

[@robertwide6592]

great vid

[@WiseOwlTutorials]

Thanks for watching!

[@SirCharlesLikesChurros]

Hi Owl. Is it possible to open a chrome tab of "my" chrome(my account)? Or will it always open a new windows in "person 1"(guest?) account when using Selenium? Thank you in advance

[@WiseOwlTutorials]

Hi Sir Charles! Check out the video on opening Chrome with a user profile in this playlist kzbin.info/aero/PLNIs-AWhQzcl3xKvF8sVL4sWRWICj_clM I hope it helps!

[@SirCharlesLikesChurros]

@@WiseOwlTutorials Thank you so much! 🙏🏻

[@josephdaquila2479]

Can you avoid copying the chromedriver.exe to a specific location by adding to the PATH? EDIT: Also, the install wizard for Selenium Basic should show where the install directory is.

[@tuyoexcelypowerbi]

MSXML2. XMLHTTP or Selenium?

[@WiseOwlTutorials]

XMLHTTP will be quicker providing that you can get the content you need. For anything involving dynamic pages with lots of javascript I'd pick Selenium.

[@tuyoexcelypowerbi]

@@WiseOwlTutorials Thanks

[@novicerider751]

Would another benefit of Selenium be cross compatibility with Excel on MacOS? Or is there already a way to do this now?

[@novicerider751]

...that is a way to use XMLHTTP on macOS

[@WiseOwlTutorials]

@@novicerider751 I will freely admit that I'm not familiar with macOS so I can't offer much in the way of advice on the topic!

[@benyeong5378]

Hi, I had tried the exact script above, but line 2, had the pop box stated automation error. Do you know the reason Sir?

[@WiseOwlTutorials]

Hi Ben, you may be missing the Microsoft .NET 3.5 Framework which you can download here www.microsoft.com/en-gb/download/details.aspx?id=21 I hope it helps!

[@clemopcl]

It may happen after 1st install that Sel.Type libr. is missing in available references... Even after restarting Excel. Then it needs to be added via Browse button.

[@WiseOwlTutorials]

A useful tip, thank you for sharing!

[@MarkStettler]

Kind input: The content in section starting at 4:27 'Downloading the Chrome Driver' is apparently outdated just a tad. I was able to follow along, but the website referenced have changed here and there.

[@WiseOwlTutorials]

Thanks Mark! Always impossible to predict how a third-party site will change after recording a video, I appreciate you taking the time to let us know!

[@JnWayn]

Are expected conditions ported over into selenium basic?

[@WiseOwlTutorials]

Hi Wayne, no, the expectedconditions class isn't part of Selenium Basic.

[@PrinceGupta-fl5kv]

Hi, is there any way to use chrome driver from a path ( where updated chromedriver installed) instead of replacing in folder. Please let me know. Thanks in advance.

[@WiseOwlTutorials]

Hi! I've never done this but apparently it's possible according to this stackoverflow.com/questions/56344625/is-there-a-way-to-change-the-chromedriver-location-for-selenium-in-vba

[@emaus8344]

Since I found so many useful things on this channel, I was wondering is there any possibility that one can extract words from a PDF documents and sort them into some kind of list?

[@WiseOwlTutorials]

Hi! You almost certainly can do this but I think you'd need to use the Adobe library (you can get this free with the Acrobat SDK). Alternatively, you can open a PDF in Microsoft Word and use VBA to extract the information you need.

[@ariangarrate721]

Hi. This video is wonderful. It opened up many doors in doing automation of reports. I just have a little problem. So I have successfully start a chrome using laptop then, then i also tried it in desktop unit but I am getting an Automation Error in Set MyBrowser = New Selenium.ChromeDriver. I'm using version 90 of chrome. Hope you can help me. Thanks

[@WiseOwlTutorials]

Hi Arian! Another viewer pointed out that SeleniumBasic is dependent on .NET Framework 3.5 which isn't installed by default with Windows 10. Here's a link with some instructions which you might find useful! docs.microsoft.com/en-us/dotnet/framework/install/dotnet-35-windows-10

[@ariangarrate721]

I see. Thank you Andrew. Appreciate it.

[@WiseOwlTutorials]

@@ariangarrate721 No problem!

[@抹茶ラテ-y4o]

Thank you so much for your video. It helped me a lot. Though there is one issue and I wonder if you could help? I’ve successfully opened Chrome using the VBA code, however when I tried to navigate it to a website, I encountered an error massage and couldn’t do it. The error message says “Run-time error ‘0’: SeleniumError invalid argument: user data directory is already in use, please specify a unique value for -user-data-dir argument, or don’t use -user-data-dir” What could be the cause of this error and how can I fix it?

[@WiseOwlTutorials]

Hi there! Sorry, I haven't experienced that error so I don't know the answer

[@抹茶ラテ-y4o]

@@WiseOwlTutorials Thank you for your response. I’ll try to look into this further.

[@WiseOwlTutorials]

@@抹茶ラテ-y4o I think that Stackoverflow is always a good place to start stackoverflow.com/search?q=Selenium+invalid+argument+user+data+directory+is+already+in+use

[@ayushshah8416]

How can I install Selenium Basic on MacOS? The exe file can't be run and the GitHub repository linked does not contain any alternative installation method for Mac users. Any help would be greatly appreciated! Thanks!

[@WiseOwlTutorials]

I don't think that there is a version of SeleniumBasic compiled for Excel for Mac, sorry!

[@hadibq]

👍👍

[@WiseOwlTutorials]

Thanks!

[@techsalesforce]

Hey, is it possible to control an already opened chrome window?

[@WiseOwlTutorials]

Hi! I've seen examples of code in other languages to do this but not for VBA. Selenium is designed to work with a fresh browser each time.

[@lcho9871]

Just in case you hit the "Automation error" check if the .Net Framework 3.5 was already on.

[@WiseOwlTutorials]

A useful tip, thanks for sharing!

[@novicerider751]

I'm getting this error too. Could you please explain to me what you mean by check if the .Net Framework 3.5 was already on? Thanks!

[@WiseOwlTutorials]

@@novicerider751 Hi there, you might find this set of instructions useful! docs.microsoft.com/en-us/dotnet/framework/install/dotnet-35-windows-10 I hope it helps!

[@lcho9871]

@@novicerider751 From (1) control panel (Win 10), (2) select Programs and Features, (3) On your left hand top corner, click "Turn Windows features on or off (4)A little pop-up modal will appear and check the item .Net Framework 3.5 (include .NET2.0 and 3.0) which should be very much the first item. And that's...best of luck.

[@Josh-qm5xd]

@@lcho9871 Damn. You deserve all the medals for this *simplified* walk-through. Thank you!!

[@aigoproject]

Hello, I have done everything according to this tutorial, but when I run the code, it says "Object variable or With block variable not set". May I ask why that is the case? I am using Chrome v. 97.0.4692.71 and its corresponding driver. Thanks!

[@WiseOwlTutorials]

Hi! When you click Debug, which line of code is highlighted?

[@attapontiwaranusorn2531]

Hi Andrew, I'm new with Selenium on VBA. I have downloaded the chrome driver matched with my Google Chrome. Once I navigating to the target website. The chrome browser is launching for a while and then it's close itself automatic. Can you please advise ? Appreciated.!!

[@WiseOwlTutorials]

Hi there! The browser closes itself automatically when the variable which references it goes out of scope. This shouldn't happen until your code has finished running of course! Declaring the variable at the module level helps to keep the browser open when the subroutine ends as the variable will still be in scope. Does your browser close before your code finishes?

[@attapontiwaranusorn2531]

@@WiseOwlTutorials Thanks for your reply. No, it''s close after finish my code. My code is very simple as follows. Should I add any scripts ? Please help to advise. Sub SuperloadUpload_Selenium() Dim driver As New Selenium.ChromeDriver Url = "www.google.com" driver.Start driver.Get Url End Sub

[@WiseOwlTutorials]

@@attapontiwaranusorn2531 Please take a look at the video from 10:13, it shows how to declare your variable at the module level. I hope it helps!

[@thesheeptradewallstreetliv8451]

what is internet disconnect ????? it should wait and try again .. how to do this

[@timematters2668]

Hi, thank you very much for your work, but I have a problem, that is I am trying to get something in the webpage with xpath, everything works fine, but if I run the chrome headlessly, I am not able to get the data, do you have any idea why this would happen?

[@WiseOwlTutorials]

Hi there, I'm afraid that I don't know but it seems to be a fairly common issue (I suspect you've seen most of the following links) stackoverflow.com/questions/56460451/selenium-vba-cant-find-xpath-with-google-chrome-in-headless-mode stackoverflow.com/questions/45624732/selenium-webdriver-is-unable-to-locate-element-in-chrome-headless-mode github.com/SeleniumHQ/selenium/issues/4477 Sorry I couldn't help!

[@timematters2668]

@@WiseOwlTutorials That's okay, thanks anyway, love your videos.

[@WiseOwlTutorials]

@@timematters2668 No problem, hope you find a solution!

[@Daniel-ro4se]

Hi Andrew, thank you for this wonderful collection of videos ! i have been dealing with Selenium Basic since last week but never could make it run :D i searched everywhere i could, tried different versions of Slenium and google drives 93, 92, 91, ( my chrome version is 92.0.4515.159 ) but still error :D i cant change the installation folder address while setup, it is C:\Program Files\SeleniumBasic\ i coppied the folder and its files to C:\Users\Dellsa\AppData\Local and then coppied google drive to both of these folders, ( i have the installation folder now in both of the above mentioned addresses) but still error :D well, the error is "failed to create chrome process". can you please advise me what to do? i cant really find a solution.

[@WiseOwlTutorials]

Hi Daniel! I'm really sorry but I don't know why it's not working for you. I have the same version of Chrome (92.0.4515.159) and the Chromedriver that I've just downloaded and installed from here chromedriver.storage.googleapis.com/index.html?path=92.0.4515.107/ (to check that the most up to date version works for me). The only thing I would advise are the things that you've already tried 😕

[@Daniel-ro4se]

@@WiseOwlTutorials Thanks for your reply. Do you think it s doable to sign in to youtube to upload a video in the channel via excel?

[@WiseOwlTutorials]

@@Daniel-ro4se Hi Daniel, in principle, yes but I think that it would be remarkably difficult and would almost certainly be the worst way to do it 😀 Using the KZbin API provides a much better way to do this sort of thing developers.google.com/youtube/v3/guides/uploading_a_video I hope that helps!

[@Daniel-ro4se]

@@WiseOwlTutorials ❤

[@renanbernardino9004]

Hello, My macro keeps showing this error : "system.component.win32exception line 80 in processExt.cs Acess denied" and i'm not able to open any webpage, using chrome or other navigator. Could you help me solve this problem?

[@WiseOwlTutorials]

Hi Renan, I'm sorry I've not experienced that problem so I'm not sure what to advise other than Googling the error message. I hope you find a solution!

[@rolandtobiasz]

I was hoping that you could help me. I have a website with a group of elements that I am capturing using : Set cClasses = drv.FindElementsByClass("ci"). Within each element there is a javascript:void(0) href with a class of "yes" or "no". How would I go about selecting the javascript:void() "yes/no" element and actually clicking it? This is the code with the javascript:void() element within the cClasses elements: ::before 19 ::before 6

[@WiseOwlTutorials]

Hi Roland, can you share the URL of the page you're using?

[@derrellrose7020]

I keep getting a runtime error. I've loaded the driver with the same root 120 since that's the version of chrome available now. Please help?

[@WiseOwlTutorials]

Hi! Does the error provide a description or a number? If this is the first time you're running SeleniumBasic on your current machine, you may also need to enable or install the Microsoft .NET Framework 3.5 Here's how learn.microsoft.com/en-us/dotnet/framework/install/dotnet-35-windows I hope it helps!

[@jaredthomas9246]

I am getting a Cannot find chrome binary error. There does not appear to be a VBA solution from what I can find online.

[@WiseOwlTutorials]

Hi Jared, sorry I haven't encountered that error so I'm not sure of the solution.

[@rodrigoordenes4858]

could you help me with this question. How do you send an enter to selenium chrome vba?. Thank you

[@WiseOwlTutorials]

Hi Rodrigo! You can do something like this using the SendKeys method Private cd As Selenium.ChromeDriver Sub PressEnter() Dim InputEle As Selenium.WebElement Set cd = New Selenium.ChromeDriver cd.Start cd.Get "the-internet.herokuapp.com/key_presses?" cd.Wait 1000 cd.SendKeys cd.Keys.Enter End Sub You can also apply the SendKeys method to a specific element if you prefer. I hope that helps!

[@tilakthedefiler]

TIPS You should run the installation of Selenium as Administrator if you want to use it with TaskScheduler

[@WiseOwlTutorials]

Good to know, thanks!

[@johnclark851]

Andrew, I am running Win 11, MS 365 and i get "Automation Error" - any ideas?

[@johnclark851]

Never mind, I saw the replies regarding .Net3.5 - worked flawlessly!

[@WiseOwlTutorials]

@@johnclark851 Ahh you beat me to it!

[@manikandanp1610]

Actually I am getting error "Rin-Time error '-2146232576 (80131700)': Automation error" in set statement. Can you team help me out. I have completed setup as per your instructions. I am using excel 2007.

[@WiseOwlTutorials]

Hi Manikandan, do you have .NET Framework 3.5 enabled? The answer on this page describes how to do this stackoverflow.com/questions/52669749/trying-to-automate-chrome-with-selenium-vba-automation-error/52880298

[@pfaleite]

Hi 2 All! I get a type mismatch when trying the code? Can anyone help?

[@B.BarathKumar]

Hi Sir.. could you please tell me how to open a "insecure" websites by using selenium in VBA. I am searching it for more than 10 days but no luck.

[@WiseOwlTutorials]

Hi Barath, sorry but I don't know the answer to that one.

[@B.BarathKumar]

@@WiseOwlTutorials Thank you sir for your reply. Your selenium videos helped me to complete some web scrapping automations in my company. Thanks a lot

[@emaus8344]

Hello! Is it possible to get unknown words from one of the translators, for example, if I want the word to be translater from EN to DE, I type it to my program and I get back the translation? Sorry if my question makes no sense, I am not good at programming.

[@WiseOwlTutorials]

Hello! You can use Selenium to work with Google Translate, sure! I've just added a video to show how this works although it's only available to channel members at the moment kzbin.info/www/bejne/p4mVhWh_d9yIpbs

[@emaus8344]

@@WiseOwlTutorials Is there any chance that I can use it on other websites like Linguee? Thank you for you time!

[@WiseOwlTutorials]

@@emaus8344 I had not heard of Linguee but I've created a basic example and yes, it's fairly straightforward. I'd recommend watching part 57.2 and 57.4 which show you the techniques you'll need. I hope it helps!

[@emaus8344]

@@WiseOwlTutorials Thank you a lot!

[@vijayalakshmibadigeru4479]

I am getting automation error I have installed as per the chrome version only.. how to solve it. Please help.

[@WiseOwlTutorials]

Hi! Another viewer pointed out that SeleniumBasic is dependent on .NET Framework 3.5 which isn't installed by default with Windows 10. Here's a link with some instructions which you might find useful! docs.microsoft.com/en-us/dotnet/framework/install/dotnet-35-windows-10

[@sky6396]

Hi can u help me? I want send error . i have screenshot error . How send to you?

[@WiseOwlTutorials]

Hi Sajad, I'm sorry but we don't do that for free. You might have more luck posting a question on StackOverflow.