TMGR: Excel Fails Using Tmgr View Object Without Name Property (155536)
The information in this article applies to:
- Microsoft Team Manager
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 95 7.0a
- Microsoft Excel for Windows 5.0
- Microsoft Excel for Windows 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
| Modification Type: | Minor | Last Reviewed: | 9/13/2006 |
|---|
| Keywords: | kbdtacode kbinterop kbProgramming KB155536 kbAudDeveloper |
|---|
|