Project Viewer 365 provides support for all MS Project standard views like Gantt Chart, Task Sheet, Network Diagram, Project Calendar, Task Usage, Resource Usage, Team Planner, etc. Project Viewer 365 looks and feels exactly like MS Project! This leads to a very beautiful looking project planner that is easily modified.Project Viewer 365 is an intuitive solution for project planning and project collaboration perfect for individual Project Managers and/or small teams working in fast-paced collaborative environments which may be across disparate geographic locations. With the time and date formatting it is very easy to read and very organized I can see by person, what everyone has to do: Once entered, I can now view my results in two ways. The result is that I can enter in my tasks, and assign the tasks resources, dates, notes, and location: Once I find that link then I can copy over any data I want. I loop through the resources available, then the assignments to those resources, then find which task the assignment is. If ActiveProject.Tasks(t) = ActiveProject.Resources(r).Assignments(a).Task ThenĪctiveProject.Resources(r).Assignments(a).Text3 = ActiveProject.Tasks(t).Text2ĪctiveProject.Resources(r).Assignments(a).Text2 = Month(ActiveProject.Tasks(t).Start) & "/" & Day(ActiveProject.Tasks(t).Start)ĪctiveProject.Resources(r).Assignments(a).Text1 = Format(ActiveProject.Tasks(t).Start, "H:mm am/pm")ĪctiveProject.Resources(r).Assignments(a).Text4 = Format(ActiveProject.Tasks(t).Finish, "H:mm am/pm")ĪctiveProject.Resources(r).Assignments(a).Notes = ActiveProject.Tasks(t).Notes See below: Public Sub copy_task_location_to_resource_location()įor r = 1 To įor a = 1 To ActiveProject.Resources(r).Assignments.Count
For example Text2 for a resource is not equal to Text2 for a task.įor this reason the only way to copy between the two sets is through use of VBA. So I discovered that fields that are assigned to tasks are not the same fields assigned to resources even if they have the same name. The first one would duplicate the task information while the second one would show the Text2 data from the Resource itself (e.g. Depending on the need, choose one of the asn.Text2 =. the fields shown in the Task Usage view). The second loop copies data to the assignment's task fields (e.g.
the fields you see in the Resource Usage view). The first loop in this code copies the task-level data to the assignment's resource fields (e.g. ' transfer data to show in the Task Usage view ' transfer data to show in the Resource Usage view Using a macro, you can copy the task-level data to the assignment-level data.
To complicate things further, there are two sets of "custom" fields at the assignment level-one for tasks and one for resources. The Text2 field shown is the one from the assignments. What appears to be task information shown in the Resource Usage view is actually the assignment information.
0 kommentar(er)
