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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Resource Usage summary work is 0h 0
Object model - assignment fields where resource is unassigned 2
Resource Usage view (2007) 1
Need some PWA help 0
Unable to retain values in custom fields 0
MS Project. Real progress of the project, % complete 1
Grouping the same Resources Names and summarizing % Allocation frommultiple files in one master file 0
resource pool - sharer file copy and delete causes resource pool toshow double usage 1

Top