Skip to content

Need help with MS Project Macro!!!

Owen WilliamsMember for 14 years 10 months
Created
1
3
0
Hi,

Im very new to writing Macos, especially when it comes to Microsoft Project. I need a specific macro that carrys out the following actions:

Lets say I have a project with the following data...

Unique ID --- Task Name --- Start --- Finish
1 --- A1 --- 01/01/11 --- 01/02/11
2 --- A2 --- 01/01/11 --- 01/02/11
3 - -- A3 --- 01/01/11 --- 01/02/11
4 --- B1 --- 01/01/11 --- 01/02/11
5 --- B2 --- 01/01/11 --- 01/02/11
6 --- C1 --- 01/01/11 --- 01/02/11
7 --- C2 --- 01/01/11 --- 01/02/11
8 --- C3 --- 01/01/11 --- 01/02/11
9 --- C4 --- 01/01/11 --- 01/02/11
10 --- D1 --- 01/01/11 --- 01/02/11

(Unique ID as an added new column)

and I import (copy/paste) the following updated schedule to the original:

Task Name --- Start --- Finish
A1 --- 01/02/11 --- 01/03/11
A2 --- 01/01/11 --- 01/02/11
B1 --- 01/01/11 --- 01/02/11
B2 --- 01/01/11 --- 01/02/11
B3 --- 01/01/11 --- 01/02/11
C1 --- 01/01/11 --- 01/02/11
C2 --- 01/02/11 --- 01/03/11
C3 --- 01/02/11 --- 01/03/11
D1 --- 01/01/11 --- 01/02/11
D2 --- 01/01/11 --- 01/02/11

I would like to update those original task's start/finish dates whilst still retaining their unique ID numbers and add+delete tasks on the updated schedule, resulting in the output:

Unique ID --- Task Name --- Start --- Finish
1 --- A1 --- 01/02/11 --- 01/03/11
2 --- A2 --- 01/01/11 --- 01/02/11
4 --- B1 --- 01/01/11 --- 01/02/11
5 --- B2 --- 01/01/11 --- 01/02/11
11 --- B3 --- 01/01/11 --- 01/02/11
6 --- C1 --- 01/01/11 --- 01/02/11
7 --- C2 --- 01/02/11 --- 01/03/11
8 --- C3 --- 01/02/11 --- 01/03/11
10 --- D1 --- 01/01/11 --- 01/02/11
11 --- A2 --- 01/01/11 --- 01/02/11

The whole purpose is to retain the unique ID number each time. This would be done for schedules with 1000s of tasks so a manual option is not viable.

Any help asap is much appreciated!

1 reply

Oldest first
  1. 0
    Rafael Davila ·

    http://www.techrepublic.com/b

    http://www.techrepublic.com/blog/tech-manager/importing-a-vendors-excel-schedule-into-microsoft-project/3373

    I no longer use MSP but recall MSP provides a Unique ID field that can be of use in case you need it. Perhaps better than a user field as as far as I can recall there is no way to prevent duplicates in MSP fields [while other software can].

    The bad thing about this field is that you have no control on it, still can be of use.

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?