Automate Actual Hours from Excel

[daved37]

Hello,

I created an export from Project to Excel that includes: Task Name,
Work, Actual Work, Work Remaing...blah blah.

I have over 900 resources on my project, so manually entering in actual
hours is just not an option. How can I create vba code to import
updated actual hours for each task? Any help or ideas to streamline
this process would be much appreciated!!

Many Thanks!

Dave

 

[Jan De Messemaeker]

Hi,

I've developped similar modules for several customers and the very first
advice to give is EXPORT UNIQUE ID's: tasks names do change, people add new
tasks so the ID changes,... and the returning hours can't get posted in MS
Project or are posted to the wrong task.

Second thing that comes to mind, the base object to be handled by the
resource is the ASSIGNMENT, not the task. When there is only one resource to
each task this need isn't that burning but who will guarantee you?

Thirdly, a piece of advice: don't think it's a "couple of hours' work" job:
it's a slmaal but realistic application thatneeds quite some effort to be
made to work
HTH

 

[JulieS]

Hi Dave37,

Please post your question to the Microsoft.public.project.developer
newsgroup as this one is attempting to shut down.

Julie

 

[daved37]

Hi Jan,

I always export Unique ID's....I've learned that the hard way a little
while ago. hahaha

I have a few weeks to develop this, I knew it would take some work! It
always does!

Thanks,
Dave