PS
I should have clarified it's not possible to check the .Ready state with all
dialogs and situations, though in a quick check it should work with your
particular error message.

Peter T

"Peter T" <peter_t@discussions wrote in message
...
While an Excel dialog is displayed normally you cannot automate Excel.
This can pose a dilemma if you are not sure what the dialog is, why it is
displaying and is it waiting for the user to handle (whilst gone for a
coffee) or triggered due to some action of your own code.

Assuming at least you have an object reference to the application you can
try something like this (either in advance or after catching the error)

If xlApp.Ready = False then
some dialog showing or user in edit mode
loop with a timer until .Ready = true or abort
or perhaps even SendKeys (or API equivalent) an Esc to dismiss the known
dialog


Regards,
Peter T


"Michael G." wrote in message
...
There is one UI instance of Excel 2007 up with an error message and
when I try to instantiate the worksheet component through VB.Net I get
this error: It seems that the UI instance is blocking access to the
worksheet component.

VB.Net Error:
"Creating an instance of the COM component with CLSID
{00020820-0000-0000-C000-000000000046} from the IClassFactory failed
due to the following error: 80010001."


Excel UI Error:
The file you are trying to open test.xls is in a different format than
specified by the file extension.

VB.Net Code:
Dim MainWorkSheet As New Microsoft.Office.Interop.Excel.Worksheet