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! 
Need help with MS Project Macro!!!
Forum Sponsor
Top Posters
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts
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.