You need chromedriver to control your Google Chrome with Selenium.
chromedriver needs to be updated according to the version of the Google Chrome.
This page introduces how to update it.
Firstly, let's update your Google Chrome to the latest version only if you don't have any specific reasons.
Please check the URL below to update the Google Chrome.
Update Google Chrome | Google Chrome Help
Take a version number(*A), like 117.0.5938.63, on somewhere after updating.
① Download the latest chromedriver.exe from the URL below
https://googlechromelabs.github.io/chrome-for-testing/
Click the version number that is the closest the version number you took at (*A) in "Stable"
※As of September 2023
②Access to the URL having an OS name you use.
i.e. If you use Windows 64bit, you access the URL with "win64".
*If you have no idea of your Windows bit number, please check the website below.
Is my Windows PC 32 bit or 64 bit?
③ Unzip the file after downloading, and copy "chromedriver.exe" in the folder, then paste in a folder below in the PC
C:\Users\[User name]\AppData\Local\SeleniumBasic
(The folder may differ depending on PC settings)
chromedriver.exe already exists in the folder, but rewrite it.
Depending on the folder settings of Windows, the folder may be unvisible.
In case you cannot find "AppData" in the [User name] folder, refer the website below to change the settings to make hidden files visible
When you have finished by here, the environment settings are completed.
Let's try your Macro to check if it works without problems!
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