VBA - Automation Error

[hugonmo]

Good morning.

I'm having a problem with an automation. When i open the automation, occurs this error:

"Automation error (error 440)"... Just this, the excel does not show any more details about the error..

it's strange because on friday morning, this automation was running normally, and i didn't do any changes.. and the error does not in a specific location of the source, and any references aren't missing. :s

OBS: the automation was created on Excel 2007, but now only run in Excel 2010...


if you need, i can send for you the workbook by email.



thank's very much for the help !!!

[hugonmo]

Hi all,

the problem was solved, i just get in other computer a MSCOMCTL.OCX and put in the computers that the automation does not working and solves the problem..


thank you !