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.
REFERENCES
For additional information, please see the following article in the
Microsoft Knowledge Base:
148914 TMGR: Error with OLE Automation Between MS Excel and Team Manager
Additional query words: 1.00
Keywords: kbinterop kbprogramming kbdtacode KB155536