Microsoft KB Archive/155536

= TMGR: Excel Fails Using Tmgr View Object Without Name Property =

Article ID: 155536

Article Last Modified on 9/13/2006

-

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 Q155536



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.

