Chip Orange wrote:
Just an FYI, I don't know about Excel, but Word has defined color constants for each of it's possible colors, with names which are descriptive (such as wdYellow). It seems likely Excel would also.
Nope, the only values defined for xlColorIndex are xlColorIndexAutomatic and xlColorIndexNone.
The reason is that the indices are just indices into the workbook's palette, which is a collection of 56 completely arbitrary RGB values. That means that even though index 4 is green in the default palette, you can't count on it always being green in every workbook. So if you want to speak one of those colors as something more than R0 G0 B0 or whatever, you'll need some way to map from RGB values to color descriptions. Unfortunately, I'm pretty sure that we don't expose that functionality from Window-Eyes to scripting.
