I have developed a VBA app in Excel to collect data from several PLCs in a factory and depositing the counts into a worksheet for subsequent part counting and reconciliation. I use an ActiveX Timer called 'VBA Timer' to synchronize the time when the PLC data is read.
During this read event, the Events are disabled using the line:
Application.EnableEvents = False
On rare instances it produces an error:
Run-time error 50290
Method 'EnableEvents' of object '_Application' Failed
It could go anywhere from 1 week to 2 months before the error occurs.
I am really stumped on this one. I would appreciate any help in solving this problem.
Kind Regards,
Curt
During this read event, the Events are disabled using the line:
Application.EnableEvents = False
On rare instances it produces an error:
Run-time error 50290
Method 'EnableEvents' of object '_Application' Failed
It could go anywhere from 1 week to 2 months before the error occurs.
I am really stumped on this one. I would appreciate any help in solving this problem.
Kind Regards,
Curt