Visio ColourIndex Vs Excel Colour index. wtf?

[jeff_porter]

Maybe I'm going mad, or maybe not.

I have a text field on a visio document.

I set the colour to be pink, and the ShapeSheet shows its colour as '6'.
i.e. ShapeSheet > Character > Color

Excel sheet colorIndex table shows '6' as yellow, not pink. wtf? why are
they different?

And why, when I set the text color to light green, does the shape sheet
show the colour as a RGB value (=RGB(204,255,204)) ?

Is there anyway I can convert a Visio-ColorIndex to a a RGB value?
So that I can then use that RGB value to set the colour of a cell on a
embedded Excel sheet.

I can set the colours of the Excel cells, just not to the correct
colours since the colourIndex value means something different on Visio
vs Excel.

Jeff.

 

[JuneTheSecond]

Visio was not born in Microsoft Office group.
Details are not yet united.
It may be too long way.

 

[David Parker]

This should show you the RGB values of each color in the map:

Public Sub ListColorMap()
Dim clr As Visio.Color
For Each clr In Visio.ActiveDocument.Colors
Debug.Print clr.Index, clr.Red, clr.Green, clr.Blue
Next clr
End Sub

Visio is moving away from using the index numbers, so you are encouraged to
us RGB or HSL