Answer by Yuriy L. ·
@ Per B.
"Automation error" is a very generic type of error – all it says is that Component Object Model (commonly referenced as COM) object experienced some error and thus could not perform the request from VBA code.
For the Agent Recorder versions 12.3.x and 12.4.x scripts, this
is often caused by the absence of .NET 2.0 runtime in the environment. Please check Control Panel’s Program and
Features. There should be a line similar
to "Microsoft .NET Compact Framework 2.0". For the most of the contemporary operating
systems .NET 2.0 is installed or activated through .NET 3.5, please reference
these Microsoft publications:
But there could be, of course, other reasons for the automation error. So, if .NET 2.0 is present in your environment, it is necessary to find and correct the exact element of the code that produces the error. The correction oftentimes needs to be done not where the error is produced, but someplace earlier in the code and/or above in the code hierarchy to allow the failing request to proceed.
Hope this helps,
Kendo UI (Changing Field ID's) 5 Answers