Table name

[varan]

hi

I am writing a macro to extract actual work done for a calendar date range

When i go to Resource usage view i can see the details listed in the right which gives the actual work per day. i want to calculate the sum of this actual work for a date range. can anyone tell me from which table should i pick up the data

thank
varan.

 

[Jan De Messemaeker]

Hi Varan,

Check out the help for the TimeScaledata method.

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/index.htm
32-495-300 620

hi,

I am writing a macro to extract actual work done for a calendar date range.

When i go to Resource usage view i can see the details listed in the right

which gives the actual work per day. i want to calculate the sum of this
actual work for a date range. can anyone tell me from which table should i
pick up the data.

 

[varan]

Jane

is it possible to get the work done per day for a date range from this method. my requirement is to take a report that shows the amount of time spent on task for a period cud be a quater or a month or a week.

thanks

 

[Jan De Messemaeker]

Hi Varan,

First, if you call me Jane I'll call you Tarzan. Jan is the Dutch form of
the male name known as Jean or John in other languages

Secondly, yes. Why should I try to explain this when it's in great detail in
the Help?
You have access to every combination you can show in a Usage view (day,
week, lmonth, squarter...)

Again, it's TimeScaleData

HTH
--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/index.htm
32-495-300 620

Jane,

is it possible to get the work done per day for a date range from this

method. my requirement is to take a report that shows the amount of time
spent on task for a period cud be a quater or a month or a week.