I need a vba code which geneartes RGB combination from
Rng.Interior.ColorIndex value. The reason why i want to do this is
because Interior.ColorIndex value differs for 2003 and 2007 .

I am getting the colour from excel file by Rng.Interior.ColorIndex
value and then applying it to powerpoint charts . but when i try to
do it for 2007 version powerpoint charts it is not applying the
specified colours .

Interior.ColorIndex doesn't differ between 2003 and 2007, but in 2007 the
actual colour of a cell may not be the same as the palette colour associated
with the colorindex that's applied to the cell format. That's because,
unlike earlier versions which can only be formatted with a palette colour,
2007 cells can be formatted with any colour.

Try this instead -

lngClr = Rng.Interior.Color

Have you looked into using Themes for your 2007 app's

Regards,
Peter T


"vicky" wrote in message
...
I need a vba code which geneartes RGB combination from
Rng.Interior.ColorIndex value. The reason why i want to do this is
because Interior.ColorIndex value differs for 2003 and 2007 .

I am getting the colour from excel file by Rng.Interior.ColorIndex
value and then applying it to powerpoint charts . but when i try to
do it for 2007 version powerpoint charts it is not applying the
specified colours .