Edit

Share via

Resource.AvailableTo property (Project)

  • Article

Gets the latest date that a resource is available for work on the project, as specified in the current row of the Resource Availability grid for the resource. Read/write Variant.

Syntax

expression. AvailableTo

expression A variable that represents a Resource object.

Remarks

You can set availability information on the General tab of the Resource Information dialog box in the Resource Availability grid. The current row is the row in which the date range specified by the Available From and Available To columns includes the current date.

The AvailableTo property does not return any meaningful information for material resources.

Example

The following line of code prints the latest date that the resource is available, as of the current date. If the availability period for the current date is not defined, the code prints the date before the next nearest Available From date. If no subsequent availability dates are defined, the code prints "NA".

Debug.Print ActiveProject.Resources(1).AvailableTo

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.