Resource.Availabilities property (Project)
Returns an Availabilities collection representing all the available periods defined for the resource in the Resource Availability grid. Read-only Availabilities.
expression A variable that represents a Resource object.
The Availabilities property does not return any meaningful information for material resources. Setting a value returns a trappable error (error code 1101) when applied to material resources.
The following example displays the range of dates during which the specified resource is available for work.
Sub ShowWorkAvail() Dim Avail As Availability For Each Avail In ActiveProject.Resources("Tom").Availabilities MsgBox "From " & Avail.AvailableFrom & " to " & Avail.AvailableTo Next Avail End Sub
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.