Automation Error (-2147417843)

[pansovic]

I get some nasty error message and microsoft is giving me the following solution: http://www.microsofttranslator.com/B...523/en-us?fr=1
I don't have the program VB installed but get to it through Excel and click on ALT F11

Apparently I need to install some kind of Timer but get error message as described in picture 04374638bda14a48b36512503acfc081.jpg

Anybody that can help me out?

[Leith Ross]

Hello pansovic,

Without seeing all of the code, I am making a guess. It looks like either the Timer object used in Visual Basic ( not the same language as VBA) or it could be a custom VBA Class Timer that uses the Window API Timer.

Any any event, it is missing in your code. Can you tell more about where you got the code? Can you upload your workbook for review?

[OnErrorGoto0]

Hi,
That looks like VB to me rather than VBA, so it won't work as written. Can I ask where you got the code or the workbook it resides in?

[pansovic]

The code I got from the webiste that I have mentioned in previous note. Here a copy

Please Login or Register  to view this content.

By the way what is difference between VB and VBA and does that have influence on my error?

[OnErrorGoto0]

Did you add that code in response to the error message? If so, it will not help and you should remove it, then tell us what code caused the original error.