Import actuals data from timesheets

[jennifer.pickard]

I saw in a previous posting someone asking about how they could import
the actual time from peoples excel timesheets into Project. The
recommendation was that they use a VBA to do this. I'm afraid I have
very little knowledge of VB but could probably change an existing VBA.
Does anyone have such a beast that I could try to change. The
information I need to import is very simple i.e.

<Resource Name> <Task> <Date> <Actual Time>


Previous Posting:
"Import actuals data from timesheets"
http://groups.google.co.uk/group/microsoft.public.project2000/browse_...



Is anyone able to help?


Many thanks
Jennifer


Import timesheet actuals from Excel into Project

 

[Rod Gill]

That is actually a complex macro. For example, what if someone has deleted a
task or changed its name? What about new remaining work? For reliability
you have to have a Task's Unique ID in the time sheet so task name changes
don't cause problems.

 

[jennifer.pickard]

Dear Rod,

thank you for your reply.

The task names won't change or be deleted as the source for the excel
document comes from the MS Project Plan, so that shouldn't be a
problem.

If the actuals reported are greater than the remaining time, does
project just set the remaining time to zero? I had planned to update
the remaining time separately as this is on a task basis (could have
more than 1 person working on a task).

So the VBA should be straightforward, are these publicly available?
Therefore I could edit an existing version.

Thaks again
Jennifer

 

[Rod Gill]

Task names won't change? Someone only needs to lean on a keyboard and add or
delete one character and your code won't work. What if someone assigns a
resource to a summary task and enters hours outside the summary task's date
range? There are easily 10 or more gotchas updating Project from a time
sheet. I have worked with this over nearly 10 years now.

I have code but given the long hours and intellectual capital involved in
finding all problem areas and fixing them I'm afraid I am reluctant to give
it away for free. If you are interested in buying some code, email me direct
at rodg AT msproject-systems DOT com .

 

[jennifer.pickard]

Dear Rod,

thanks again for getting back to me. The task names won't change
because they are non-editable and cannot be deleted/changed. Sorry not
in a position to pay, I just thought as the import should be fairly
straightforward that there may be something out there.

Thanks for your time
Jennifer

 

[Rod Gill]

The import is non-trivial. It's the task names in Project that change, so
your code can't find them. That's why a reliable time sheet program must
export the task names and Unique ID at the beginning of the week and then
import Unique ID (name is irrelevant) and work etc.

Anything else will fail regularly with much admin work!