Share via

Availabilities Collection Object

  • Article
Project Developer Reference

Contains a collection of Availability objects.

Example

Using the Availability Object

Use Availabilities(Index), where Index is the availability index number, to return a single Availability object. The following example returns the availability information from the first line of the Resource Availability grid for the specified resource.

Visual Basic for Applications 
  MsgBox ActiveProject.Resources("Tom").Name & " is available from " & _
    ActiveProject.Resources("Tom").Availabilities(1).AvailableFrom & " to " & _
        ActiveProject.Resources("Tom").Availabilities(1).AvailableTo & "."

Using the Availabilities Collection

Use the Availabilities property to return an Availabilities collection. The following example displays the range of dates during which the specified resource is available for work.

Visual Basic for Applications 
  Dim Avail As Availability

For Each Avail In ActiveProject.Resources("Tom").Availabilities
MsgBox "From " & Avail.AvailableFrom & " to " & Avail.AvailableTo
Next Avail

Use the Add method to add an Availability object to the Availabilities collection. The following example adds a line to the Resource Availability grid showing that the specified resource is available only half-time during the month of April.

Visual Basic for Applications 
  ActiveProject.Resources("Tom").Availabilities.Add "4/1/2002", "4/30/2002", 50

See Also