I have used SeleniumBasic-2.0.9.0.exe and Latest stable release: ChromeDriver 81.0.4044.69", and click on Verify.
The issue i'm getting in my code is the
runtime error -2146232576 automation error
in the 5th line of the Code(
Statement)
Though i have performed all the tasks of installing Selenium , also installed the Chrome Driver too, then the references too in the VBA editor. But other system just cant go past Automation Error.
Hi Amit,
The code in the workbook and the code in your image are not the same. I can run the code in the workbook you attached without issue.
As I said in my reply to you on the blog post - in the code in your image, you have not declared or initialized the variable count so when you try to evaluate it in the statement
While (Len(Range("A" & count)) > 0)
You get that error.
Phil
Hi Phil,
Sorry the wrong image got attached.
But the code which is perfect ran in one system.
But doesn't run in the other.
It says, "runtime error -2146232576 automation error" in this "Set Driver = CreateObject("Selenium.ChromeDriver")" line of code.
This is the main issue now.
Please have a look into this.
Thanks
Amit
Hi Amit,
Without being at the PC in question hard to say. You say the code works on another machine so the issue isn't the code.
Things I'd check:
- Is Chrome installed and working?
- Do the installed versions of Chrome and ChromeDriver match? Note that as mentioned here https://www.myonlinetraininghub.com/web-scraping-filling-forms they must match
Regards
Phil
