Thanks to both of you! (did you guys have some sort of contest to see who could get "color dictionaries" out first!!! ;) )
Chip > -----Original Message----- > From: Aaron Smith [mailto:[email protected]] > Sent: Tuesday, June 02, 2009 4:09 PM > To: [email protected] > Subject: Re: automatic announcement of Excel cell background color > > On 6/2/2009 3:57 PM, Ron Parker wrote: > > The reason is that the indices are just indices into the workbook's > > palette, which is a collection of 56 completely arbitrary > RGB values. > > Doh! That explains it. > > > 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. > > You can use the ColorDictionaries object's LookUp method to > do this, I > think. If you get the RGB value from the Color property of the cell's > Font property, you can use that value to create a Window-Eyes Color > object, and pipe that through the Lookup method to get a string back > describing the color. Or, if you don't get an exact match, > you can speak > "Shade of" like Window-Eyes does. > > Aaron > > -- > To insure that you receive proper support, please include all past > correspondence (where applicable), and any relevant information > pertinent to your situation when submitting a problem report to the GW > Micro Technical Support Team. > > Aaron Smith > GW Micro > Phone: 260/489-3671 > Fax: 260/489-2608 > WWW: http://www.gwmicro.com > FTP: ftp://ftp.gwmicro.com > Technical Support & Web Development >
