On Error Resume Next Can't skip the error

[YasserKhalil]

Hello everyone
I am using selenium in vba, and the file is sent to some users. I tried this code

Code: Select all

Sub CheckSeleniumInstallation()
    Dim bot As Object
    
    On Error Resume Next
    Set bot = CreateObject("Selenium.ChromeDriver")
    On Error GoTo 0
    
    If Not bot Is Nothing Then
        MsgBox "Selenium is installed!"

    Else
        MsgBox "Selenium is not installed or the specified object could not be created."
    End If
End Sub

But I still got an error
activex component can't create object

How to skip the error and display a message to the user to install Selenium first

[HansV]

When I run your code, I get:

S2490.png

Is your macro stored in a standard module or in a class module?

[YasserKhalil]

The code is in standard module
I expect that it will result as you did but the code insists on displaying the error.

[HansV]

Sorry, no idea. Anyone else?

[rory]

Perhaps you have your VB Editor set to Break on all errors?

[YasserKhalil]

Hello Mr. Rory
You are right. I have changed this option and forgot about it. Everything is OK now.

[HansV]

Good call, rory!

@Yasser: "Break in Class Module" is the best setting.

[YasserKhalil]

Thanks a lot my tutor for the information.