M
meg99
using 2003. I have 46 tasks in a schedule. Task 41 is the Launch
date. Everything prior to that is backward planned from that date. I
have a user form in which the user enters the Launch date. I want to
find the launch task and change the start date. Here is some of the
code:
EditGoTo ID:=1
Find Field:="Name", Test:="equals", Value:="Launch"
Set Tsk = ActiveCell.Task
TaskID = Tsk.Application.ActiveCell.Task
launchdate = Format(launchdate, "mm, dd, yy")
Tsk.Start = launchdate ' launchdate comes from the user form
Problem: Although "Find Field" finds the correct task, TaskID
registers as 45 instead of 41. Consequently, the launchdate is set on
the wrong task.
anybody have a clue?
meg99
date. Everything prior to that is backward planned from that date. I
have a user form in which the user enters the Launch date. I want to
find the launch task and change the start date. Here is some of the
code:
EditGoTo ID:=1
Find Field:="Name", Test:="equals", Value:="Launch"
Set Tsk = ActiveCell.Task
TaskID = Tsk.Application.ActiveCell.Task
launchdate = Format(launchdate, "mm, dd, yy")
Tsk.Start = launchdate ' launchdate comes from the user form
Problem: Although "Find Field" finds the correct task, TaskID
registers as 45 instead of 41. Consequently, the launchdate is set on
the wrong task.
anybody have a clue?
meg99