Understanding: "BUG: VB Hangs While Automating Excel Using OLE Control"

[Don Wiss]

I have an application that for some users Excel freezes when they print.
Printing is done with a User Form that has lots of checkboxes and a few
buttons. If it does freeze, it tends to be on the same sheet. It appears
that this is the bug:

http://support.microsoft.com/kb/q181889/

Except in my case it is intermittent. And I'm not sure if my User Form is
an OLE control. One thing I could do, is to close the form before printing.
All I'd have to do is create a global variable with the checkbox values.
Does anyone have any insight on this?

Don <www.donwiss.com> (e-mail link at home page bottom).

 

[Tom Ogilvy]

That would be if you embedded excel in a word document or powerpoint slide
and then tried to automate that embedded instance. Doesn't sound like that
is what you are doing.