Hello,
A while ago I've written the following macro, which worked at the time.
But now when I run it, it gives me the following error on the line: bot.Start "chrome", "een webadres"
Run-time error '33':
SessionNotCreatedError
session not created: This version of Chrome driver only supports Chrome version 120
Current browser version is 122.0.6261.112 with binary path....
(Driver info: chrome driver = 120.0.6099.71)
I found multiple threads on forums that I should update the driver, so I've downloaded the following new driver from https://googlechromelabs.github.io/chrome-for-testing/#stable:
chromedriver win64 https://storage.googleapis.com/chrome-for-testing-public/122.0.6261.111/win64/chromedriver-win64.zip 200
I've stored it in the SeleniumWrapper folder and unblocked it through the file properties.
When I run the chrome driver from the SeleniumWrapper folder, I get the following:
Starting ChromeDriver 122.0.6261.111 (9d4c1072da62b411b351a38b9ed6214ab236aa7b-refs/branch-heads/6261@{#1015}) on port 9515
Only local connections are allowed.
Please see https://chromedriver.chromium.org/security-considerations for suggestions on keeping ChromeDriver safe.
ChromeDriver was started successfully.
(I'm sorry if I'm not formatting this correctly, but I don't how to add this in cmd-window-format)
To me it seems to be the driver for the Chrome browser 122-version, but I'm still getting the same error when I run my Excel macro.
However, in the selenium-Folder there also is a file "QuickTest.vbs" and when I run this Chrome gets opened.
Does anyone know what else I need to do to get this working again through VBA?
Kind regards,
Frauke Stevens
A while ago I've written the following macro, which worked at the time.
Code:
Sub GetWOZValues()
Dim bot As New WebDriver
Dim addresses As Range
Dim counter As Integer
Dim elements As Object
Dim wozValue As Single
'open the Chrome browser
bot.Start "chrome", "<een webadres>"
bot.Get "/"
bot.Window.Maximize
On Error Resume Next
bot.FindElementByClass("btn--close").Click
On Error GoTo 0
But now when I run it, it gives me the following error on the line: bot.Start "chrome", "een webadres"
Run-time error '33':
SessionNotCreatedError
session not created: This version of Chrome driver only supports Chrome version 120
Current browser version is 122.0.6261.112 with binary path....
(Driver info: chrome driver = 120.0.6099.71)
I found multiple threads on forums that I should update the driver, so I've downloaded the following new driver from https://googlechromelabs.github.io/chrome-for-testing/#stable:
chromedriver win64 https://storage.googleapis.com/chrome-for-testing-public/122.0.6261.111/win64/chromedriver-win64.zip 200
I've stored it in the SeleniumWrapper folder and unblocked it through the file properties.
When I run the chrome driver from the SeleniumWrapper folder, I get the following:
Starting ChromeDriver 122.0.6261.111 (9d4c1072da62b411b351a38b9ed6214ab236aa7b-refs/branch-heads/6261@{#1015}) on port 9515
Only local connections are allowed.
Please see https://chromedriver.chromium.org/security-considerations for suggestions on keeping ChromeDriver safe.
ChromeDriver was started successfully.
(I'm sorry if I'm not formatting this correctly, but I don't how to add this in cmd-window-format)
To me it seems to be the driver for the Chrome browser 122-version, but I'm still getting the same error when I run my Excel macro.
However, in the selenium-Folder there also is a file "QuickTest.vbs" and when I run this Chrome gets opened.
Does anyone know what else I need to do to get this working again through VBA?
Kind regards,
Frauke Stevens
Laatst bewerkt: