TMGR: Excel Fails Using Tmgr View Object Without Name Property

ID: Q155536

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

If a Microsoft Excel Visual Basic for Applications macro attempts to place the name of a Team Manager view in a cell in a worksheet by using a Team Manager View object without specifying the Name property, the cell may be set to #N/A or #VALUE!, or Microsoft Excel may stop responding.

WORKAROUND

Use the Name property explicitly with the View object. For example, in a macro that uses something like


    For Each oView in oTmgr.Views
     ActiveCell.Value = oView

use:


   For Each oView in oTmgr.Views
     ActiveCell.Value = oView.Name

MORE INFORMATION

The default property of a Team Manager View object is the Name property; however, a Microsoft Excel macro may not correctly interpret a Team Manager View object without explicitly specifying a property.

STATUS

Microsoft has confirmed this to be a problem in the 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:

Q148914 TMGR: Error with OLE Automation Between MS Excel and Team Manager

Additional query words: 1.00

Keywords : kbinterop kbprg kbdta kbdtacode
Version : WINDOWS:5.0,5.0c,7.0,7.0a,97
Platform : WINDOWS
Issue type :