Resource.Overallocated 屬性 (Project)

True 是表示 如果資源已過度分派。 唯讀的 Boolean。

語法

expression。 Overallocated

表達 代表 Resource 物件的變數。

註解

Overallocated 屬性不會傳回對材料資源有意義的任何資訊。

範例

下面範例會顯示使用中專案過度分派的資源百分比。

Sub DisplayOverallocatedPercentage() 
 
 Dim R As Resource ' Resource object used in For Each loop 
 Dim NOverallocated As Long ' Number of overallocated resources 
 
 For Each R In ActiveProject.Resources 
 If R.Overallocated Then NOverallocated = NOverallocated + 1 
 Next R 
 
 MsgBox (Str$((NOverallocated / ActiveProject.Resources.Count) * 100) _ 
 & " percent (" & Str$(NOverallocated) & "/" & Str$(ActiveProject.Resources.Count) _ 
 & ")" & " of the resources in this project are overallocated.") 
 
End Sub

支援和意見反應

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