Table of contents
TOC
Collapse the table of content
Expand the table of content

Availability Object (Project)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

Represents a line from the Resource Availability grid for a resource. The Availability object is a member of the Availabilities collection.

Using the Availability Object

Use Availabilities(Index), whereIndex 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.

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

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.

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.

ActiveProject.Resources("Tom").Availabilities.Add "4/1/2012", "4/30/2012", 50

Methods

Name
Delete

Properties

Name
Application
AvailableFrom
AvailableTo
AvailableUnit
Index
Parent
© 2018 Microsoft