FIX: Microsoft Excel 95 Doesn't Respond Correctly to GetObjectLast reviewed: October 29, 1997Article ID: Q153025 |
The information in this article applies to:
SYMPTOMSAttempting to use the GetObject function to return a reference to a running instance of Microsoft Excel 95 results in the error 429:
"OLE Automation server can't create object."The identical code works correctly with a running instance of Microsoft Excel 5.0.
CAUSEMicrosoft Excel 95 fails to correctly register itself in the Running Object Table. The GetObject function can be used with the correct syntax to obtain a currently running instance of Microsoft Excel 95 for use with OLE automation. Microsoft Excel 95 requires one additional step to ensure that it will respond to the OLE request. The code outlined below uses the SendMessage API to tell Microsoft Excel 95 to listen for requests for objects.
RESOLUTIONTo work around this problem, follow these steps:
STATUSMicrosoft has confirmed this to be a bug in Microsoft Excel 95. This bug has been fixed in Microsoft Excel 97.
MORE INFORMATION
Steps to Reproduce Problem
REFERENCESFor additional information, please see the following article in the Microsoft Knowledge Base:
ARTICLE ID: Q114347 TITLE : INFO: OLE Automation Objects with GetObject and CreateObject |
Additional query words: GetActiveObject
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |