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

 

[prashanth.sharangapani]

Dear All,

just to add further, I do not have Project Server.

Thanks,
Prashanth

 

[Mike Glen]

Hi Prashanth,

Perhaps you might like to try posting on the
microsoft.public.project.developer newsgroup (forum). Please see FAQ Item:
24. Project Newsgroups. FAQs, companion products and other useful Project
information can be seen at this web address:
http://project.mvps.org/faqs.htm

Mike Glen
Project MVP

 

[vanita]

Hi Prashanth

Apart from macros, why not have linked columns between spreadsheet and ms
project file.

In your spreadsheet file in a column have tasks listed in the same sequence
as in msp file. Accordingly have other columns for data reqd. in msp. Then
copy and paste in msp file as linked columns (through paste special > linked
and text option). Now whatever changes happen in your spresdsheet file would
automatically be updated in the msp file.

I hope it helps.
Vanita

 

[Rod Gill]

Hi,

I'm afraid you can't paste-link to the usage view daily. Even if you could I
would not recommend it as links a very risky. Every time you move either
file, rename wither file or over-write either of them you roll the dice and
sooner or later your file will corrupt itself!

There isn't a "basic" macro as each spreadsheet is different and the
different ways each collection of users use to create data is different!

However all the code you need is in my book, or I can write some specific
for you if you email me.



--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com