Results 1 to 2 of 2

Thread: Need help with MS Project Macro!!!

  1. #1
    Join Date
    Nov 2011
    Location
    london
    Posts
    3

    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!
    Last edited by meatloaf_o; 28-11-2011 at 11:47 PM.

  2. #2
    Join Date
    Jun 2011
    Posts
    635

    Re: Need help with MS Project Macro!!!

    I have a useful link which can be helpful for you to work with macros in Microsoft Project. You can navigate through multiple options here.

    Using Macros Microsoft Project

Similar Threads

  1. Replies: 4
    Last Post: 20-04-2012, 11:22 PM
  2. Replies: 5
    Last Post: 13-01-2012, 05:20 PM
  3. MS Project 2007 Emailing Macro
    By dmpyne in forum Microsoft Project
    Replies: 1
    Last Post: 13-12-2011, 12:56 AM
  4. MS Project 2007 - macro buttons grayed out
    By jbarbara11@yahoo.com in forum Microsoft Project
    Replies: 1
    Last Post: 10-12-2011, 02:45 AM
  5. MS Project export to PDF via Macro
    By rosscosack in forum Windows Software
    Replies: 1
    Last Post: 20-05-2010, 12:56 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,653,303,019.00263 seconds with 17 queries