Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-29-2011, 04:39 AM
meatloaf_o meatloaf_o is offline Need help with MS Project Macro!!! Windows XP Need help with MS Project Macro!!! Office 2003
Novice
Need help with MS Project Macro!!!
 
Join Date: Nov 2011
Location: london
Posts: 1
meatloaf_o is on a distinguished road
Default 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!
Reply With Quote
Reply

Thread Tools
Display Modes


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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:24 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft