Adding colour to shapes for 56 pg org chart at once & not page by

[MRFoster]

Hello all,
after running an org chart I would use the color add on to add
colour to all shapes using the staff level. I have to do this page by page.
Do you think it would be possible to write a VBA script that would look at
all shapes in the entire document and depending on a certain custom porperty
field add colour that way?

I am hoping to create some sort of VBA script, that would say, "Look at all
shapes in entire document, if APS6 fill shape colour green, if APS5 fill
shape colour blue and so on and so on.

Part2.
I have read many web pages reagrding updating your org chart via a data base
so that I would not have to rebuild from scratch all the itme. Can some one
recomend a text book or a link that would allow me to fully undersatnd this
claim and put it into practice?

Thank you all in advnace.

Mark
Regards,
Mark

 

[AlEdlund]

First part
yes you can write a vba macro that will check all shapes for a specific
custom property and then change the color of the shape. There are examples
in the visio sdk for reading shape custom properties and updating shape
cells using vb code.
Second part
Technically you can link visio drawings to external data several ways.
However. Currently the recommendation is to use v2007 with datalinking.
Second. The org chart wizard redraws everything (by design) when you call
it. So any changes you made to the drawing since the last time you called it
are lost.....
al

 

[MRFoster]

Thank you very much Al.

At present I utilize an excel document with some 700 employees in it and was
hoping to only be able to perhaps update differences rather than drawing the
whole org chart from the wizard function from start to finish again.

Will check the SDK package and a trial version of 2007 for your other
recommendations.

Cheers MRFoster