Why doesn't TimePhaseData read correctly?

[piedpiper11]

Can anyone explain to me why there are values reported for ActualWork when there shouldn't be in the following situation?

I'm working with a dummy MPP that I created and I've assigned Work hours to the first seven tasks (through WBS 1.1.7). When you switch to the Task Usage view, you can see that I've manually entered some ActualWork hours for the first 4 assignments (through WBS 1.1.4) but left blank the rest. TaskUsage view shows this correctly, but when I run a simple VBA program to read the TimePhasedData, it shows >0 values in ActualWork for all assignments that have any Work on them; including the assignments where I didn't enter an ActualWork number. I'm currently working through Rod Gill's wonderful book on VBA where I got the code orignally, but I'm a bit of a newbie to Project VBA generally. Run the macro called SRVersionTimePhasedDataTest() to see the results that I am confused about.

Using MSP 2013 Pro on a Win7 system
File can be accessed here:

https://www.dropbox.com/s/5otjdh38j6z34xl/TEST VBA - ReadActualWork.mpp

Scott

 

[piedpiper11]

Oops - nevermind. I figured it out. My code only changed a label, but not the actual variable to ActualWork. It works fine with the correction.

Scott

 

[piedpiper11]

Amazing what a little sleep can do for the brain

Scott