Resource Usage

S

Satya

I had thought of this possibility of looping through the assignments and
finding the lowest and the highest date for the resource but in msproject if
we view->resource usage->insert columns-> add resource start date and end
date
we get the values directly. Is it possible to get those values directly
through VBA.
 
R

Rod Gill

Hi,

Yes. In a Usage you are looking at assignment start and finish.

Try:

activecell.Task.Assignments(1).Start

and

activecell.Task.Assignments(1).Finish

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com
 
Top