Embedded Files
Selenium to control browser
Selenium to control browser
Selenium is a common framework used to control Google Chrome with VBA or Python.
This is an introduction of how to install Selenium!
What is Selenium?
What is Selenium?
Selenium is a framework which can connect Google Chrome with programs (VBA or Python etc.) as a role of bridge between them.
Therefore, our VBA tools don't work, if we control a browser with VBA and our VBA program has some problem or the Selenium has some problem, or even chromedriver connecting Selenium with Chrome has some problem...
programmed orders are delivered like this flow, VBA→Selenium→chromedriver→Google Chrome
Selenium and chromedriver are developed by the third party, not Google nor Microsoft.
If VBA or Google Chrome has some updates, Selenium and chromedriver may also need to be updated (In case of miner update, mostly not needed)
Download Selenium to your computer
Download Selenium to your computer
① Download Selenium from URL below
http://florentbr.github.io/SeleniumBasic/
Click "Release page" in the middle, then click "SeleniumBasic-*.*.*.*.exe" to save in the PC (anywhere is fine)
※As of January 2022
② Install Selenium by double clicking the downloaded "SeleniumBasic-*.*.*.*.exe" to execute
Following instructions on the screen, install it as it is (I think you can complete with just clicking "Next" and "Agree")
If you face Automation error (Install .Net)
If you face Automation error (Install .Net)
If you face this error after setting, please try this procedure, which can solve it!
①Execute "StartChrome.vbs" file in the folder below
C:\Users\[User name]\AppData\Local\SeleniumBasic\Scripts
②-1 If an installer is executed, install .Net Framework following instructions.
②-2 If an installer is executed and you see the dialog box below, just click OK to complete.
Reference setting in Excel file you execute the Macro
Reference setting in Excel file you execute the Macro
①Open the Excel file with the Macro
②Push Alt＋F11 to open VBA Editor
③Click Tools in the top Menu --> Reference
④Tick "Selenium Type Library" on
After installing Selenium, it needs to be updated to control your Chrome browser.
Please update it referring How to update chromedriver.
*The VBA scraping programs offered by Uesugi have a function which automatically updates chromedriver (not for FREE ones). In case you use them, you do not need to update manually.
If you want to get lots of information from websites by Scraping, if you want to improve your productivity of work by automation on computer, please contact Uesugi here
Page updated
Google Sites
Report abuse