Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
542 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
Posted by Andrew Gould on 18 January 2021
This video shows you how to install the web drivers for the Microsoft Edge and Opera web browsers for use with Selenium in VBA. You'll learn how to copy the web drivers to your Selenium installation folder and how to switch between Chrome, Edge and Opera in your VBA code. You'll also find out why the Firefox browser is no longer supported.
See our full range of VBA training resources, or test your knowledge of VBA with one of our VBA skills assessment tests.
There are no files which go with this video.
There are no exercises for this video.
You can increase the size of your video to make it fill the screen like this:
Play your video (the icons shown won't appear until you do), then click on the full screen icon which appears as shown above.
When you've finished viewing a video in full screen mode, just press the Esc key to return to normal view.
To improve the quality of a video, first click on the Settings icon:
Make sure yoiu're playing your video so that the icons shown above appear, then click on this gear icon.
Choose to change the video quality:
Click as above to change your video quality.
The higher the number you choose, the better will be your video quality (but the slower the connection speed):
Don't choose the HD option shown unless your connection speed is fast enough to support it!
Is your Wise Owl speaking too slowly (or too quickly)? You can also use the Settings menu above to change your playback speed.
From: | Jonathan U |
When: | 21 Feb 23 at 22:57 |
Hello Andrew G,
I am not new to SeleniumBasic for excel. I have found that other languages for which Selenium is available have the ability to attach to an already open instance of a web browser. I need to be able to do this because there is a policy that prevents my excel from "creating child processes". I am able to launch the Microsoft Edge driver, for example, from my command prompt and I specify the "remote debugging port" (number) in my command line. I should be able to use "Selenium.EdgeDriver.SetCapability" to set the "debuggerAddress" to be what I specified as the debugging port number in the launch, but this does not work.
Please tell me there is a way to connect to a browser that I have already launched.
Thank you,
Jonathan U
From: | Andrew G |
When: | 22 Feb 23 at 08:03 |
Hi Jonathan!
Sadly, I'm almost certain that this isn't possible with SeleniumBasic and VBA. It's a common question but I've never encountered an answer that works.
From: | namita |
When: | 08 Jul 22 at 18:47 |
Hi Andrew, hope you are doing well. I am indebted to your help whenever I get stuck in automation in the past.
This is to ask your help about recent issues in my selenium automation with VBA on both Chrome and Edge browsers.
Now the errors say "unknown error: unexpected command response" on Chrome browser and "unknown error: cannot determine loading status" on Edge browser.
This error has come up after both Chrome and Edge browsers upgraded automatically, hence bringing compatibility issues with their respective drivers. I even tried upgrading both chromeDriver and EdgeDriver manually with closest matching edge and Chrome browser release numbers.
Can you please rescue me from this issue.
FYI, I made no change in running code before or after browsers upgradation.
Many thanks in advance,
Namita
From: | Andrew G |
When: | 09 Jul 22 at 08:50 |
Hi!
Apparently this is a known bug with a version 103 of ChromeDriver. The suggestion is to either roll back to 102 or upgrade to 104. I hope it helps!
From: | J.A. Clark |
When: | 20 Jan 22 at 21:56 |
Is there a Wise Owl tutorial describing how to use Excel VBA and Selenium driver to scrape data from a website that has the 'next' and 'previous' links to go through all results of a search and then add each page to a sheet (Example: https://dcca.secure.force.com/ActiveConsultantContractor)?
Thank you for all your efforts :-)
From: | Andrew G |
When: | 21 Jan 22 at 08:50 |
Hi! We don't have anything specific to that page but at a glance it doesn't appear to complicated - the page is well structured and both the table and the Next button have ID attributes. The Class attribute of the Next button changes when you're on the last page. The basic approach would be:
Go to start page
Begin looping
Get a reference to the table
Write the table to an Excel sheet
Get a reference to the Next button
If the Class of the button indicates that you're on the last page, exit the loop, otherwise Click the button
Repeat the loop
I hope that points you in the right direction!
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.