Article ID: 112030
Article Last Modified on 10/10/2006
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q112030
SUMMARY
If you use the CreateObject function in a Visual Basic procedure in
Microsoft Excel to create an OLE Automation object, and you then request
information from the created object, if you switch back to Microsoft Excel
(the Client application), you may receive the following error message:
Microsoft Excel is waiting for another application to complete an OLE
action.
When you click OK, the error message is redisplayed within a few seconds.
CAUSE
When you create an OLE Automation object (run a server application) in
a Visual Basic procedure in Microsoft Excel, if you send that object
a command, the server must finish processing the command before you
can continue working in Microsoft Excel.
WORKAROUND
To break out of the infinite loop (the dialog box that contains the
error message above continues to appear), when you work with OLE
Automation objects in Microsoft Excel, cancel or complete the request
in the server application. For example, if a dialog box is open in
the server application, close the dialog box, and then return to the client
application (in this case, Microsoft Excel). You can then choose OK in the
dialog box that contains the above error message and it will not appear
again.
REFERENCES
For more information about the CreateObject Function, click the Search
button in the Visual Basic Reference and type:
Additional query words: 5.00c 8.00 97 XL97 error message XL
Keywords: kbprogramming KB112030