ResourceGroups object (Project)

Represents all of the resource-based group definitions. ResourceGroups is a collection of Group objects.

Using the ResourceGroups Collection

Use the ResourceGroups property to return a ResourceGroups collection. The following example lists the names of all the resource groups in the active project.

Dim rg As Group 
Dim rGroups As String 
 
For Each rg in ActiveProject.ResourceGroups 
 rGroups = rGroups & rg.Name & vbCrLf 
Next rg 
 
MsgBox rGroups

Use the Add method to add a Group object to the ResourceGroups collection. The following example creates a new group that groups resources by their standard rate and then modifies the criterion so that the resources are sorted in descending order.

ActiveProject.ResourceGroups.Add "Resources by Rate", "Standard Rate" 
ActiveProject.ResourceGroups("Resources by Rate").GroupCriteria(1).Ascending = False

Remarks

For resource groups where the group hierarchy can be maintained and cell color can be a hexadecimal value, use the ResourceGroups2 collection object.

Methods

Properties

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.