Run-time error '-2147417848 (80010108)

[Jeffery B Paarsa]

Hello;

This one has thrown me off completely.... I have got a template with one
single multipage Userform that runs a rather lengthy VBA code to print
different documents off of different word template "*.dot" based on the user
request. This code was working till recently...

Well if I run this template/code via VBA debug facility I have no problem
but when I run the code without debug facility by just double clicking on the
template I get the following dialog... "Run-time error '-2147417848
(80010108) Automation error The object invoked has disconnected from its
clients. Clicking on the Help button does not give much of help... Clicking
on the End button will display another dialog box of "Automation error... etc
followed by dialog box asking to "Send Error Report" or "Don't Send" butt
ton...

What could have gone wrong? that this program runs on the debug mode but
fails outside of debug mode? How can I catch what is wrong?

Regards,

 

[Jeffery B Paarsa]

It seems that there is a Logical AND/OR limitation on VBA... I was able to
find my problem after breaking down number of my Logical AND in an IF
statement... I was doing close to 40 Logical AND... and sounds like VBA can
not handle it... As soon as I broke down it into 2-3 IF statment my problem
was resolved.