I'd like to change the color of shapes in a visio drawing programmatically...

[jeff guthlaf]

How do i link a shape to a database and depending upon what the value is in
that database, change the color of the shape? (i need to do this for
multiple shapes in the document so do i link the entire drawing and then
either in VBA or the shapesheets, enter code for this.) what would the code
look like? cheers!

 

[David Parker [Visio MVP]]

You can update the formula in the shape.Cells("FillForegnd").Formula cell
with either:
a number from 0 to 23 (or more if you customise the color map)
a valid RGB reference
a valid HSL reference

If you have a grouped shape, then you may need to enumerate through its
sub-shapes too.

You could store your colors in a lookup table, and automatically update the
color of simple shapes using the Database Wizard

Also, if you have Visio Professional 2003, then there is a Color Byy Value
add-on undr Building Plan.