Excel VBA Introduction Part 57.3 - Using Different Web Browsers with Selenium

Поделиться
HTML-код
  • Опубликовано: 10 дек 2024

Комментарии • 44

  • @rishabhjain3708
    @rishabhjain3708 3 года назад +2

    Hello Andrew,
    I have been watching your videos for quite a long time now and they all are very detailed and well explained. You are really excellent at what you do. Thank you for sharing your precious knowledge!

    • @WiseOwlTutorials
      @WiseOwlTutorials  3 года назад

      Thank you Rishabh, I'm happy to hear that you've been finding the videos useful. Thanks for taking the time to leave a comment and for watching!

  • @bencole8301
    @bencole8301 3 года назад +2

    Hello Andrew. Another absolutely amazing video delivered by an absolute tutorial God. I seriously enjoy the information, delivery and manner by which you deliver the content. I cannot praise you highly enough. I shall be a Wise Owler for life now and already thinking about other videos I can begin to learn from. Thank you so much for sharing your knowledge, skills and for being a genuinely good human...

    • @WiseOwlTutorials
      @WiseOwlTutorials  3 года назад +1

      Ah Ben, you're making me blush! Thanks for the kind comments and happy to hear that you're enjoying the videos!

  • @Damned943
    @Damned943 3 года назад +1

    Thanks again for a great tutotial!

  • @officialknowledgebooster7839
    @officialknowledgebooster7839 3 года назад +1

    Great Andrew Sir

  • @tg5441
    @tg5441 3 года назад +1

    Great Video. Thanks

  • @KhalilYasser
    @KhalilYasser 3 года назад +1

    Thanks a lot, my tutor. Amazing tutorial

  • @yannylaurel1588
    @yannylaurel1588 3 года назад +1

    Thank you sooooo veryy much!!

    • @WiseOwlTutorials
      @WiseOwlTutorials  3 года назад

      You're so very welcome Yanny, thanks for watching!

  • @juanpablohorn6642
    @juanpablohorn6642 3 года назад +1

    Great video Andrew! I was wondering if it would be possible to see how to work with emails through selesium. Gmail for example. Compose emails and maybe attach some file to it would be interesting.

    • @WiseOwlTutorials
      @WiseOwlTutorials  3 года назад +1

      Thanks Juan Pablo, I'm not sure if Selenium is the best choice for manipulating Gmail (Google provide an API for working with Gmail) but I'll put your suggestion on the list!

    • @juanpablohorn6642
      @juanpablohorn6642 3 года назад +1

      @@WiseOwlTutorials Thanks for your reply! I ask this because every time I say I can manipulate outlook with VBA I get the question if I can do the same with Gmail.

  • @manuelmarquez4365
    @manuelmarquez4365 2 года назад

    Good afternoon from Spain. I've ben following your web scraping tutorials and they are brilliant, amazing and comprehensible. I would appreciate enormously treat the issue "error 10 stale element reference exception" and how to solve it with vba and selenium.

    • @WiseOwlTutorials
      @WiseOwlTutorials  2 года назад

      Buenos días Manuel! Stale element errors occur when you use a variable to store a reference to an element on the page, when the page (or some part of it) is refreshed the original reference to the element is "stale". You can use the same code you used to get the element originally to get a reference to the refreshed version of the element. I hope that helps!

  • @Fly0High
    @Fly0High 3 года назад

    Wow, where did that "validate" button popped from? I had no idea it was there (Running Excel Mac 2011 and, yes, works as intended).

  • @paulsherwood9572
    @paulsherwood9572 2 года назад

    Dear Andrew, like the other commenters I find your teaching style amazingly clear and you have helped me enormously. Unfortunately the methods using Internet Explorer directly from Access/Excel don't work through Edge, IE is being phased out, and some of the old websites I work with need Edge to open in IE mode. I have tried to use the IEDriver but am struggling to get it to work. Could you please extend this video with an example of how to open a webpage in IE mode in Edge and automate it using Selenium rather than the techniques in the earlier video series? Thank you very much Paul

    • @WiseOwlTutorials
      @WiseOwlTutorials  2 года назад

      Hi Paul! I'm afraid I don't know how to do this but I wonder if Method 3 in the answer shown here might help you? stackoverflow.com/questions/70619305/automating-edge-browser-using-vba-without-downloading-selenium

    • @paulsherwood6723
      @paulsherwood6723 2 года назад +1

      Thank you very much for the pointer, I will have a good look at it. Kind regards Paul

    • @WiseOwlTutorials
      @WiseOwlTutorials  2 года назад

      @@paulsherwood6723 Cheers Paul, I hope it works!

  • @mayurgawde2182
    @mayurgawde2182 3 года назад +1

    I like your videos...

  • @tanliemnguyen4264
    @tanliemnguyen4264 2 года назад

    I’ve watched a lot of your videos about selenium to automate web. But error occurs when I clicked previewer button and a new tab (about blank) open. If I want to download pdf file, I have to switch to this tab and click the download button. It’s not successful and I got ‘timeout not receiving message from renderer” . I tried many solutions but can not solve this problem.

    • @WiseOwlTutorials
      @WiseOwlTutorials  2 года назад

      Hi! There could be many reasons for this, you could try some of these suggestions
      stackoverflow.com/questions/62889739/selenium-gives-timed-out-receiving-message-from-renderer-for-all-websites-afte
      stackoverflow.com/questions/40514022/chrome-webdriver-produces-timeout-in-selenium
      stackoverflow.com/questions/60114639/timed-out-receiving-message-from-renderer-0-100-log-messages-using-chromedriver
      stackoverflow.com/questions/59630332/timed-out-receiving-message-from-renderer-10-000
      I hope it helps!

  • @liviapenariol2847
    @liviapenariol2847 3 года назад

    Andrew, you are amazing!!!! But, even I update my chromedriver still appearing error. Can you help me?

    • @WiseOwlTutorials
      @WiseOwlTutorials  3 года назад

      Hi Livia! I'm not really an expert on Selenium troubleshooting but I can recommend StackOverflow as a great source of help stackoverflow.com/
      Try searching for the text of your error message and if don't find any matches you can post your own question. There are many people there waiting to help!
      I hope that's useful!

  • @katznatz
    @katznatz 3 года назад

    How to remove "chrome is being automated by test software"? Browser infobar

    • @WiseOwlTutorials
      @WiseOwlTutorials  3 года назад

      Here's one way ruclips.net/video/rh8umiDtQ8c/видео.html

  • @yashchawla8360
    @yashchawla8360 3 года назад

    Is there any way to know if the download is completed? When we try downloading something using selenium.

  • @Krishnauniyal
    @Krishnauniyal 3 года назад

    hi my browser is getting closed after run the code, how to stop that

    • @WiseOwlTutorials
      @WiseOwlTutorials  3 года назад

      Hi Krishnanauniyal, try declaring your ChromeDriver variable as shown in the video. I hope it helps!

  • @DM-py7pj
    @DM-py7pj 3 года назад

    Are you running selenium basic successfully with windows 10?

    • @KhalilYasser
      @KhalilYasser 3 года назад +1

      I am using Windows 10 64 Bit and it is working well. Install NET Framework 3.5

    • @DM-py7pj
      @DM-py7pj 3 года назад +1

      @@KhalilYasserThanks. I am testing my hypothesis that the underlying .NET framework might be a limitation. I'd be interested to know which .Net version Andrew is using in this case? The actual version being used as it is possible to have multiple installed versions.

    • @WiseOwlTutorials
      @WiseOwlTutorials  3 года назад +1

      I am, yes. Windows 10 Version 20H2 Build 19042.746
      I have the following .NET Framework versions installed:
      2.0.50727.4927 Service Pack 2
      3.0.30729.4926 Service Pack 2
      3.5.30729.4926 Service Pack 1
      4.0.0.0
      4.8.04084
      I hope that helps!

    • @DM-py7pj
      @DM-py7pj 3 года назад

      @@WiseOwlTutorials Thank you.
      Do you know which is being picked up by selenium basic? Maybe not that easy to determine but I guess first on env path? I can no longer use selenium with VBA due to what I suspect is related to underlying .NET that is being picked up. Odd as never used to have a problem.

    • @WiseOwlTutorials
      @WiseOwlTutorials  3 года назад +2

      @@DM-py7pj Hmm, I could be wrong but I think that's unlikely. The source code from GitHub contains three Visual C# Class Library projects, each of which are set to target the .NET 3.5 Framework. I can't think of anything that would cause the final libraries to use a different .NET Framework version. All I can suggest are the obvious things such as reinstalling the 3.5 Framework and checking that your web driver is up to date but I'm sure that you've done that already!