Class not registered

[SQUIDD]

Hi

So beyond me this one.
I am getting a runtime error in the below code.

BUT

Only when i open the excel file from a scheduled task in task scheduler.

The code runs just fine if i manually open the file

the macro is called upon workbook open BTW.

Any ideas? thanks.

dave

Dim mybrowser As Selenium.ChromeDriver
Sub get_ip()
Set mybrowser = New Selenium.ChromeDriver 'error is here
mybrowser.AddArgument "--headless"
mybrowser.Get "https://www.showmyipaddress.eu/"
ip1 = mybrowser.FindElementByXPath("/html/body/div[2]/div/div/div/div[1]/div[1]").Text
'at this point i email myself the ip1.
ThisWorkbook.Save
Application.Quit
End Sub

 

[Micron]

Task is being run on same computer as the one you're using to open manually? If not, seems like
- a reference library is missing from the workbook code project on the other pc, or
- a dll or similar is not installed and/or registered in Windows on it, or
- is stored under a profile/account and isn't available to the account running the task, or
If it is the same pc and account, I have no idea.

 

[SQUIDD]

Hi micron.

Thanks for your response.

Yes, the task is on the same pc as when I run it manually.

Ohhh. Lol. These things are fun.

 

[Micron]

But are you the one running the task?
BTW, I'm assuming the error message is reflected in your post title as you didn't actually state what it is.

 

[SQUIDD]

I am running the task. Yes.

The task scheduler essentially opens the excel workbook. Vba takes it from there.

 

[SQUIDD]

Run time error.

2147221164(80040154)

Class not registered.

So if I open the excel file. I can run the code. No problem. All works.

If task scheduler opens the excel file the code errors.

Thanks for your help. Although it’s an odd one.

 

[Micron]

Then I'm afraid I have no other ideas except to suggest you ask Google. Perhaps the answer is found in post 3 here

Scheduled task fails with "Class not registered" error - Kinook Software Forum

Scheduled task fails with "Class not registered" error [VBP] General Discussion

www.kinook.com

 

[SQUIDD]

Ok. I found the problem.

On the task scheduler I had to click the setting to

Configure for windows vista windows server 2008.

I had it set to windows 10. Although I am running 10.

Works now.

 

[Micron]

Interesting! Thanks for posting a solution.

 

[SQUIDD]

Thanks for your help.

Always like to post solutions. Maybe will help others. ?