Microsoft KB Archive/112030

= Infinite Loop If OLE Automation Server Busy =

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.

