VBA code to Update Plan on a Page shapes based on shape data
Budget: $30 – $250 AUD
VBA code is required to Read TaskData tab's Table "ShapeData" and Update shape's location based on start/finish dates on the Poap
Poap will contain 2 types of Shapes
Milestones-shapename starting with "Milestone_"
Tasks-shapename starting with "Task_"
Method e.g.
Loop through all the shapes(Milestone/Task type shapes only) in the Poap
If Shape found, go to TaskData tab "Shapedata" table and check if the ShapeID is Found
If Found , capture the start and finish date and update the Shape location based on the Poap timeline
Note: Poap header month cell size could be reduced or expanded by the user, and the size need to calculated through code to figure out the shape location
Please refer attached sample file
Poap will contain 2 types of Shapes
Milestones-shapename starting with "Milestone_"
Tasks-shapename starting with "Task_"
Method e.g.
Loop through all the shapes(Milestone/Task type shapes only) in the Poap
If Shape found, go to TaskData tab "Shapedata" table and check if the ShapeID is Found
If Found , capture the start and finish date and update the Shape location based on the Poap timeline
Note: Poap header month cell size could be reduced or expanded by the user, and the size need to calculated through code to figure out the shape location
Please refer attached sample file