Creating customized GANTT view.
Mike
You can not do this manually in MS Project and hence vba also can NOT
produce such output.
The easiest way to do it is to get the output in Excel. The "Analze
Timescaled Data in Excel..." of analysis tool bar transfers data to excel
but bars are not transferred. You can add code to shade the cells for tasks
where resource figures are not zero which gives an effect of bar. Or you can
even draw a bar using a rectangles in excel with start and end points
interpolated from dates to columns in Excel. Of cource this is a simple
concept but takes immense amount of effort. I had done a similar thing some
years ago in my previous company for creating reports of Scurves overlapped
on barcharts along with time phased figures and the program ran into
thousands of lines.
I think doing it using VB is impractical, eventhough it is not impossible.
Regards
Venkata Krishna
Quote:
> Is it possible using VBA to create customized GANTT view that would show
the
> bar for the activity and on the line below it, to show the timephased
> resources something like this:
> Jan Feb Mar <<<<<< This is the
timescale
> <>===============<> <<<<<< This is the GANTT bar
> 10 10 10 <<<<< this is the sum of
> the timphased resources.
> If not, is it possible to access graphical objects in Project from VB 6 to
> create it?
> Thanks,
> Mike Robelotto
