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:
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:
CreateObject
Additional query words: 5.00c 8.00 97 XL97 error message XL
Keywords: kbprogramming KB112030