How to Improt Data via Gantt Chart?

[KarthikK]

Hi,

I have a project schedule. I would like to take the data from the Gantt
chart view. I am aware that Gantt Chart show's the way how the data is
distrubuted but i would like to get the total horus for a task for each
month. Would this be possible to do it in VBA?
Ex: I have a task like the one below

Prepare for Paper Presentation 80 dys? Mon 1/1/07 Fri 4/20/07 237 hrs
Plan the topic 8.88 dys? Mon 1/1/07 Thu 1/11/07 10 hrs
Start the Preperation 26.88 dys? Wed 1/10/07 Thu 2/15/07 180 hrs
Plan for Review 10 dys? Fri 3/2/07 Thu 3/15/07 15 hrs
Plan for Rework 10 dys? Tue 3/27/07 Mon 4/9/07 30 hrs
Present the paper 1 dy? Fri 4/20/07 Fri 4/20/07 2 hrs

The distribution in the GanttChart(Resource usage) would be something like
this
Prepare for Paper Presentation Jan: 116.33h Feb: 73.67h March: 27h April:20h

I assume these are the sum of the distribution of the child tasks under
"Prepare for Paper Presentation"

Is it possible to get the values using the (VBA Macro) for each month like
the above example?


Please let me know if you have any suggestions

Thanks
Karthik K

 

[John]

Hi,

I have a project schedule. I would like to take the data from the Gantt
chart view. I am aware that Gantt Chart show's the way how the data is
distrubuted but i would like to get the total horus for a task for each
month. Would this be possible to do it in VBA?
Ex: I have a task like the one below

Prepare for Paper Presentation 80 dys? Mon 1/1/07 Fri 4/20/07 237 hrs
Plan the topic 8.88 dys? Mon 1/1/07 Thu 1/11/07 10 hrs
Start the Preperation 26.88 dys? Wed 1/10/07 Thu 2/15/07 180 hrs
Plan for Review 10 dys? Fri 3/2/07 Thu 3/15/07 15 hrs
Plan for Rework 10 dys? Tue 3/27/07 Mon 4/9/07 30 hrs
Present the paper 1 dy? Fri 4/20/07 Fri 4/20/07 2 hrs

The distribution in the GanttChart(Resource usage) would be something like
this
Prepare for Paper Presentation Jan: 116.33h Feb: 73.67h March: 27h April:20h

I assume these are the sum of the distribution of the child tasks under
"Prepare for Paper Presentation"

Is it possible to get the values using the (VBA Macro) for each month like
the above example?


Please let me know if you have any suggestions

Thanks
Karthik K

KarthikK,
You are confusing views. The Gantt Chart is a view that includes tabular
data and graphics data. The Usage views (Resource or Task) include
tabular data and timescaled data. It sounds like what you want is one of
the Usage views. However what you cannot get from Project is a view with
timescaled data AND graphics data, unless you use a split screen (i.e.
Gantt Chart in one pane and usage data in the other pane).

None of the above requires VBA and VBA won't help unless of course you
export the data to another application (e.g Excel) where you can produce
whatever type of visual presentation you want.

John
Project MVP

 

[KarthikK]

Hello John
What i really need to do is to get the data from the Gantt chart view. The
issue is Gantt chart is only the arrangement of the available data in a
different view. It is OK If in knew the forumla on what basis the data is
being shown i can do the same in my macro. Do you have any idea on this. I a
not sure if i can attach a file or screenshot for sample to explain my problem

regards,
Karthik