#1
|
|||
|
|||
Need help with MS Project Macro!!!
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! |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I assign a macro to a button when the macro is in my personal workbook? | foolios | Excel Programming | 2 | 07-27-2011 02:41 PM |
Project 2007 Macro Performance | RMarsh | Project | 0 | 07-14-2011 03:32 PM |
Connectivity issue of Project Professional with Project Server | kashif | Project | 0 | 03-27-2009 06:37 AM |
Error 9571 when opening Project Server from Project Pro | mona | Project | 0 | 04-24-2007 07:50 AM |
Different % complete in Project Center & View a Project | mikaelbelchior | Project | 1 | 01-25-2006 12:56 AM |