Microsoft KB Archive/148914

= TMGR: Error with OLE Automation Between Excel and Team Manager =

Article ID: 148914

Article Last Modified on 8/17/2005

-

APPLIES TO


 * Microsoft Team Manager 1.0 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 95a
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Excel 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.

