A
AnnaO
I want to create the following functionality in my MS Project 2007 file
and I believe it will require programming macros.
1) I want to be able to modify the value in a custom field on multiple
tasks. For example, I have a custom date field called RDate. I want to
select multiple tasks (or use a macro and update all tasks in the
project) to a new date. Can someone help me with what the programming
logic that would be in the macro or how I can accomplish updating the
value in a custom field on multiple or all tasks?
2) After the user updates the RDate, I want the programming to
automatically update another custom date field, FDate, based on the
value in a custom Number1 field. The custom Number1 field has number of
weeks as a round number. I want to subtract the number of weeks
(displayed in Number1 field) from the date in RDate and based on that,
set the new FDate.
I will continue to search this forum, but any help is sincerely
appreciated!
Thank you,
Anna
and I believe it will require programming macros.
1) I want to be able to modify the value in a custom field on multiple
tasks. For example, I have a custom date field called RDate. I want to
select multiple tasks (or use a macro and update all tasks in the
project) to a new date. Can someone help me with what the programming
logic that would be in the macro or how I can accomplish updating the
value in a custom field on multiple or all tasks?
2) After the user updates the RDate, I want the programming to
automatically update another custom date field, FDate, based on the
value in a custom Number1 field. The custom Number1 field has number of
weeks as a round number. I want to subtract the number of weeks
(displayed in Number1 field) from the date in RDate and based on that,
set the new FDate.
I will continue to search this forum, but any help is sincerely
appreciated!
Thank you,
Anna