Application.EnterpriseResSubstitutionWizard method (Project)

Runs the Resource Substitution Wizard. Available in Project Professional only.


expression. EnterpriseResSubstitutionWizard( _ProjectList_, _PoolOption_, _RBSorResourceList_, _FreezeHorizonDate_, _UpdateProjects_, _SaveReport_, _Path_, _AssignProposedResources_, _LevelProposedBookings_ )

expression A variable that represents an Application object.


Name Required/Optional Data type Description
ProjectList Optional String A comma-separated list of portfolio projects in the database.
PoolOption Optional Long Specifies the resource pool option. Can be one of the following PjResSubstitutionPoolOption constants: pjResSubstitutionResInList, pjResSubstitutionResInProject, or pjResSubstitutionResInRBS. The default value is pjResSubstitutionResInProject.
RBSorResourceList Optional String The name of the RBS (resource breakdown structure) level to use if pjResSubstitutionResInRBS was specified in the PoolOption argument. If pjResSubstitutionResInList was specified in the PoolOption argument, the RBSorResourceList argument specifies a comma-separated list of resource names to use.
FreezeHorizonDate Optional String The date of the resource freeze horizon.
UpdateProjects Optional Boolean True if the Resource Substitution Wizard updates projects with the new resource information. The default value is True.
SaveReport Optional Boolean True if the Resource Substitution Wizard saves a report. The default value is False.
Path Optional String The directory to use when creating the report. The default value is the My Documents folder of the current user.
AssignProposedResources Optional Variant
LevelProposedBookings Optional Variant

Return value



No events are fired when using the EnterpriseResSubstitutionWizard method.

The EnterpriseResSubstitutionWizard method does not include a parameter for specifying that resources from the enterprise resource pool should be used.

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.