A
And1
Hello All
I have a Master schedule in excel which has milestones for a project and the respective tasks that are needed for the milestone. Each of these tasks come from individual developers' schedules. My task is to read the Master Schedule, get the list of tasks for each Milestone in the Master Schedule, then generate a time schedule in HTML format for each milestone by refering back to the individual schedules. That is, i am looking for ideas (a script?) that helps me opens the Master Schedule, reads the Milestones and the tasks required, refers back to the individual schedules, get the dates/time for those tasks, and generate a simple table in HTML for the milestones
One obvious way to do this is to read all individual schedules and store in memory. Then read the Master Schedule, get the task list for each milestone and query these tasks from the individual schedules and then generate the required tables.
But this seems like an round about way?? I would really appreciate if someone could give me any idea(s) or even better any code snippet that could help me
Thanks
Andy
I have a Master schedule in excel which has milestones for a project and the respective tasks that are needed for the milestone. Each of these tasks come from individual developers' schedules. My task is to read the Master Schedule, get the list of tasks for each Milestone in the Master Schedule, then generate a time schedule in HTML format for each milestone by refering back to the individual schedules. That is, i am looking for ideas (a script?) that helps me opens the Master Schedule, reads the Milestones and the tasks required, refers back to the individual schedules, get the dates/time for those tasks, and generate a simple table in HTML for the milestones
One obvious way to do this is to read all individual schedules and store in memory. Then read the Master Schedule, get the task list for each milestone and query these tasks from the individual schedules and then generate the required tables.
But this seems like an round about way?? I would really appreciate if someone could give me any idea(s) or even better any code snippet that could help me
Thanks
Andy