Project) (Assignments 物件

會包含任務或資源的 Assignment 物件之集合。

範例

使用 Assignment 物件

使用 指派 (索引) ,其中 index 是指派索引編號,可傳回單一 Assignment 物件。 下列範例會顯示指派給指定之任務的第一個資源的名稱。

MsgBox ActiveProject.Tasks(1).Assignments(1).ResourceName

使用 Assignments 集合物件

使用 Assignments 屬性,可以傳回 Assignments 集合。 下面範例會顯示分派給指定任務的全部資源。

Dim A As Assignment 

 

For Each A In ActiveProject.Tasks(1).Assignments 

 MsgBox A.ResourceName 

Next A

使用 Add 方法,可以將一個 Assignment 物件新增至 Assignments 集合。 下面範例會將索引號碼為 212 的資源新增為指定任務的新工作分派。

ActiveProject.Tasks(1).Assignments.Add ResourceID:=212

方法

名稱
AppendNotes
Delete
EnterpriseTeamMember
Replan
TimeScaleData

屬性

名稱
ActualCost
ActualFinish
ActualOvertimeCost
ActualOvertimeWork
ActualStart
ActualWork
ACWP
應用程式
Baseline10BudgetCost
Baseline10BudgetWork
Baseline10Cost
Baseline10Finish
Baseline10Start
Baseline10Work
Baseline1BudgetCost
Baseline1BudgetWork
Baseline1Cost
Baseline1Finish
Baseline1Start
Baseline1Work
Baseline2BudgetCost
Baseline2BudgetWork
Baseline2Cost
Baseline2Finish
Baseline2Start
Baseline2Work
Baseline3BudgetCost
Baseline3BudgetWork
Baseline3Cost
Baseline3Finish
Baseline3Start
Baseline3Work
Baseline4BudgetCost
Baseline4BudgetWork
Baseline4Cost
Baseline4Finish
Baseline4Start
Baseline4Work
Baseline5BudgetCost
Baseline5BudgetWork
Baseline5Cost
Baseline5Finish
Baseline5Start
Baseline5Work
Baseline6BudgetCost
Baseline6BudgetWork
Baseline6Cost
Baseline6Finish
Baseline6Start
Baseline6Work
Baseline7BudgetCost
Baseline7BudgetWork
Baseline7Cost
Baseline7Finish
Baseline7Start
Baseline7Work
Baseline8BudgetCost
Baseline8BudgetWork
Baseline8Cost
Baseline8Finish
Baseline8Start
Baseline8Work
Baseline9BudgetCost
Baseline9BudgetWork
Baseline9Cost
Baseline9Finish
Baseline9Start
Baseline9Work
BaselineBudgetCost
BaselineBudgetWork
BaselineCost
BaselineFinish
BaselineStart
BaselineWork
BCWP
BCWS
BookingType
BudgetCost
BudgetWork
確認
成本
Cost1
Cost10
Cost2
Cost3
Cost4
Cost5
Cost6
Cost7
Cost8
Cost9
CostRateTable
CostVariance
建立於
CV
Date1
Date10
Date2
Date3
Date4
Date5
Date6
Date7
Date8
Date9
延遲
Duration1
Duration10
Duration2
Duration3
Duration4
Duration5
Duration6
Duration7
Duration8
Duration9
Finish
Finish1
Finish10
Finish2
Finish3
Finish4
Finish5
Finish6
Finish7
Finish8
Finish9
FinishVariance
FixedMaterialAssignment
Flag1
Flag10
Flag11
Flag12
Flag13
Flag14
Flag15
Flag16
Flag17
Flag18
Flag19
Flag2
Flag20
Flag3
Flag4
Flag5
Flag6
Flag7
Flag8
Flag9
Guid
Hyperlink
HyperlinkAddress
HyperlinkHREF
HyperlinkScreenTip
HyperlinkSubAddress
Index
LevelingDelay
LinkedFields
附註
Number1
Number10
Number11
Number12
Number13
Number14
Number15
Number16
Number17
Number18
Number19
Number2
Number20
Number3
Number4
Number5
Number6
Number7
Number8
Number9
過度分派
OvertimeCost
OvertimeWork
擁有人
Parent
尖峰
PercentWorkComplete
Project
RegularWork
RemainingCost
RemainingOvertimeCost
RemainingOvertimeWork
RemainingWork
資源
ResourceGuid
ResourceID
ResourceName
ResourceRequestType
ResourceType
ResourceUniqueID
ResponsePending
Start
Start1
Start10
Start2
Start3
Start4
Start5
Start6
Start7
Start8
Start9
StartVariance
摘要
SV
工作
TaskGuid
TaskID
TaskName
TaskOutlineNumber
TaskSummaryName
TaskUniqueID
TeamStatusPending
Text1
Text10
Text11
Text12
Text13
Text14
Text15
Text16
Text17
Text18
Text19
Text2
Text20
Text21
Text22
Text23
Text24
Text25
Text26
Text27
Text28
Text29
Text3
Text30
Text4
Text5
Text6
Text7
Text8
Text9
UniqueID
單位
UpdateNeeded
VAC
WBS
工時
WorkContour
WorkVariance
符合

另請參閱

Project 物件模型

支援和意見反應

有關於 Office VBA 或這份文件的問題或意見反應嗎? 如需取得支援服務並提供意見反應的相關指導,請參閱 Office VBA 支援與意見反應