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. 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.