TMGR: Error with OLE Automation Between Excel and Team Manager

ID: q148914

The information in this article applies to:

Microsoft Team Manager 97
Microsoft Excel for Windows 95, versions 7.0, 7.0a
Microsoft Excel for Windows, versions 5.0, 5.0c

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:

   ARTICLE-ID: Q155536
   TITLE: TMGR: MSExcel Fails Using Tmgr View ObjectWithoutName Property

KBCategory: kbole kbprg kberrmsg KBSubcategory: TMGRVBA Additional query words: crash gpf ipf 1.00 97

Keywords          : kberrmsg kbole kbprg
Version           : 97
Platform          : WINDOWS

Last Reviewed: December 18, 1997