Macro to update MPP from Timesheet

[prashanth.sharangapani]

Dear Friends,

I have been updating my three schedules manually over the last 8
months. I now want to automate this task. Can some one provide me with
a skeleton macro to perform the following?

1. Read the time sheet data from a spread sheet.
The spread sheet would have the following on different columns -
a. the unique ID of the tasks on the MPP
b. the resource names (exactly as in the MPP)
c. the hours that have been charged to that unique ID
d. The days on the week when those hours have been charged


2. Populate the MPP with the above data
I need the data populated accurately in the task usage view - i.e.
the hours spent on a task on a particular day should go exactly to
that task on that particular day.


3. Highlight the row that has been updated
This is to help me review the changes later.


The steps that I have stated above is nothing new - I'm sure all MPP
users would be doing the same thing. Is there some method that is
already used to speed up the process of updating the MPP with
timesheet data?


Thanks!
Prashanth

 

[Jan De Messemaeker]

Hi,

Done this several times indeed, here are some recommendations:

- Don't use task.uniqueid and resourcename; use assignment.uniqueid instead
(which you write when creating the timesheets from MSP)
- Entering timescaled data into project is done by generating a timescale
values array through the timescaledata function.

Hope this helps,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf