TMGR: Error with OLE Automation Between Excel and Team Manager (148914)
The information in this article applies to:
- Microsoft Team Manager
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 95 7.0a
- Microsoft Excel for Windows 5.0
- Microsoft Excel for Windows 5.0c
This article was previously published under Q148914 SYMPTOMS
When you use OLE Automation between Microsoft Excel and Microsoft Team
Manager, and use the FormulaR1C1 method to fill ranges in Microsoft Excel
with data from Microsoft Team Manager, you may receive the following error
message:
The program has performed an illegal operation and will be shut down.
When you click the Details button, you see the following information:
Excel caused an invalid page fault in module OLEAUT32.DLL
CAUSE
This behavior occurs because the FormulaR1C1 method is incapable of
obtaining the default value for a given object. For example, the View
object in Microsoft Team Manager has a default value of its Name property
such that
View = View.Name
when you access it through generalized OLE Automation. However, the methods
used when accessing object values must be written to use the default object
value.
Example
The MsgBox method is a Microsoft Excel method that uses the default value
of an object if no specific property of the object is specified. For
example
MsgBox View.Name
-and-
MsgBox View
yield the same results - the name of the Team Manager view. However if you
use the latter through the Microsoft Excel FormulaR1C1 range method, for
example
ActiveCell.FormulaR1C1 = View
Microsoft Excel displays an error.
WORKAROUND
When you use the FormulaR1C1 method, always address the specific property
of an object that you want to place into the range. Use
ActiveCell.FormulaR1C1 = View.Name
instead of
ActiveCell.FormulaR1C1 = View
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article. We are researching this problem
and will post new information here in the Microsoft Knowledge Base as it
becomes available.
REFERENCES
For additional information, please see the following article in the
Microsoft Knowledge Base:
155536 TMGR: MSExcel Fails Using Tmgr View ObjectWithoutName Property
| Modification Type: | Minor | Last Reviewed: | 8/17/2005 |
|---|
| Keywords: | kberrmsg KB148914 |
|---|
|