Traverse the Gantt Chart Table

[phreed]

This is a VBA question:

I see methods for creating, setting and deleting bar formats from the
gantt bar style table.
(i.e. GanttBarStyleEdit, GanttBarStyleDelete)
What I don't see how to tranverse the current set of gantt bar styles.

I do see how to assign custom formats to each task...
http://masamiki.com/project/allgreen.txt

Currently, I am deleting all the gantt bar styles with
GanttBarStyleDelete Item:="*"
and then creating the styles as I want.
What I really would like is search for and modify specific bar styles.

peace

 

[Jean-Yves]

HI,

Sorry, I know nothing in project, only XL.
In XL, this could be done like

Dim mybar as "application.msoGantBar" 'without s
for each mybar in msoGantBars 'with s
'get the name of each bar so you can find yours
debug.print mybar.name
next
msoGantBars("your bar name").style .........
hope this help as I just arrived on this group
Jean-Yves

 

[phreed]

When you say "XL" I presume you mean Microsoft Excel?
If that is true, where do you find:
application.msoGantBar
or
application.msoGantBars
?

 

[Jan De Messemaeker]

Hi,

AFAIK Bar Styles are "write only" and cannot be read.
HTH

 

[Jean-Yves]

HI again,
yes, excel.
Did you find the project object model in VBA help.
Or when you write a sub, trye appplication. (dot), and then the autosugest
would give you some possibility.
But search in help first.
Regards
JY