P
Priustoric
I've googled, and searched, and waded, and I don't know where else to
turn. I'm sure I'm just googling the wrong search terms, since I can't
be the only one with this problem:
I have an excel diagram embedded on a form... when I go activate it, if
Excel isn't "available" (e.g. open dialog box or uncommitted values),
it doesn't work. Depending on how I'm doing it (e.g. via form interface
or VB) I have different problems. It doesn't seem to create a trappable
error, it just gives me the "switch to/retry" or "would you like to
reinstall feature" dialogs. Easy cure of going to Excel, close the
dialog box or hitting enter to commit a value, but my users don't know
that. The sendmessagetimeout shows "responding" at any time delay that
doesn't create an overflow, and I can't figure out how to (or even if I
can) use WaitForInputIdle, so I don't know if that would work.
I've been able to (after much angst) figure out if there's a dialog box
open, but I can't seem to get any cure for the uncommitted values.
Also, some common boxes (such as the print properties box, etc) aren't
in the dialog box class, so they cause the problem, but aren't
recognized by my boorish attempts at finding dialog boxes.
So, how do I tell if Excel is available for use? Or am I just WAY off
base?
Thanks in advance for any help.
gko
turn. I'm sure I'm just googling the wrong search terms, since I can't
be the only one with this problem:
I have an excel diagram embedded on a form... when I go activate it, if
Excel isn't "available" (e.g. open dialog box or uncommitted values),
it doesn't work. Depending on how I'm doing it (e.g. via form interface
or VB) I have different problems. It doesn't seem to create a trappable
error, it just gives me the "switch to/retry" or "would you like to
reinstall feature" dialogs. Easy cure of going to Excel, close the
dialog box or hitting enter to commit a value, but my users don't know
that. The sendmessagetimeout shows "responding" at any time delay that
doesn't create an overflow, and I can't figure out how to (or even if I
can) use WaitForInputIdle, so I don't know if that would work.
I've been able to (after much angst) figure out if there's a dialog box
open, but I can't seem to get any cure for the uncommitted values.
Also, some common boxes (such as the print properties box, etc) aren't
in the dialog box class, so they cause the problem, but aren't
recognized by my boorish attempts at finding dialog boxes.
So, how do I tell if Excel is available for use? Or am I just WAY off
base?
Thanks in advance for any help.
gko