Task.WBSPredecessors 属性 (Project)
获取工作分解结构 (WBS) 代码的前置任务,以列表分隔符分隔。 只读 String。
语法
expression。 WBSPredecessors
表达 一个代表 Task 对象的变量。
示例
以下示例要求用户输入任务标识号,然后即可提供其前置任务的更易于识别的 WBS 代码分解形式。
Sub EnumeratePredecessors()
Dim Task As Task
Dim PredTasks As Tasks
Dim ID As Long
Dim Predecessors As String
Dim List As String
Dim Count As Integer
ID = CLng(InputBox$("Enter the ID number of the task you wish to examine:"))
Set Task = ActiveProject.Tasks(ID)
Set PredTasks = Task.PredecessorTasks
Predecessors = Task.WBSPredecessors
Count = 1
If PredTasks.Count = 0 Then
List = "Task " & Task.UniqueID & ", " & Task.Name & ", has no predecessors."
Else
List = "Predecessors to task " & Task.UniqueID & ", " & Task.Name & ":" & vbCrLf & vbCrLf
Do While InStr(Predecessors, ListSeparator) <> 0
List = List & PredTasks(Count).Name & ": " & Mid$(Predecessors, 1, InStr(Predecessors, ListSeparator) - 1) & vbCrLf
Predecessors = Right$(Predecessors, Len(Predecessors) - InStr(Predecessors, ListSeparator))
Count = Count + 1
Loop
List = List & PredTasks(Count).Name & ": " & Predecessors
End If
MsgBox List
Set PredTasks = Nothing
Set Task = Nothing
End Sub
支持和反馈
有关于 Office VBA 或本文档的疑问或反馈? 请参阅 Office VBA 支持和反馈,获取有关如何接收支持和提供反馈的指南。