Programmatically changing Hours Worked fields

[slide242]

Hi all. I am using Project 2003 Pro and I am trying to programmatically change the hours worked fields for specific dates.

Here are the particulars: I have a CSV or XLS. I am attempting to parse the file to extract some project information, and store the hours an employee worked on specific dates. Am I missing these fields in the object model? When I look at the relevant fields in XML, the hours worked value seems to be encrypted. So, any ideas about how I can change the work fields for specific dates using VBA?

I appreciate any information anyone has. Thanks.

 

[PDQBach]

I haven't done any work using XML but be aware of a couple of things:

1. Work (actual, estimated, baseline, etc.) is a TimeScaleData field so you'll need to understand how to work with that.

2. It comes out in minutes so if you see 60, it's really an hour and if you see 480 it's really a day.

3. You'll have all sorts of interesting combinations that you need to consider: what happens if you enter actuals before the task start date? what happens if they are after the task start date? What happens if you enter them during the start/finish interval but the task is fixed work?