ResourceGroups Object (Project)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

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

© 2016 Microsoft