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

 

[Rod Gill]

Several ways:

1) Save the schedule as an Excel Template then update Actual hours for
Assignments then import to Project again.

2) Have records in Excel then import and merge.

3) Use a time sheet system (search the web or use Project Server) that
automatically updates your project.

4) Have hours in a database or Excel then use VBA to import the hours and
update the schedule.

Note for importing hours, it is safest to have Task and Resource Unique ID's
to work with. The danger is that if a Task or Resource Name is changed, then
the update won't work. A unique ID avoids this problem. There are also a
number of gotcha's that you need to be aware of, so the development route
will take some time.

 

[daved37]

Rod,

All great ideas, I ended up using the first one and it works pretty
good. I'm not done with it yet, but the hard stuff works, just got do
some stuff in Excel now.

Again, Thanks!!

Dave