Hi,

Part of my VB.NET app reads the colour of a VB.Net chart and applies that same colour to a matching Excel chart:

Code:
arrChart_Colour(byteChart_Number) = embchartHTCD.ChartAreas(0).BackColor
With arrChart_Colour(byteChart_Number)
    xlchartSingle_Chart.ChartArea.Format.Fill.BackColor.RGB = RGB(.R, .G, .B).ToString
Now all this works fine when I update Excel 2007 charts, but all the colours are wrong with Excel 2010 charts.

I know the RGB colour numbers are somehow different between the 2 versions of Excel as have run into the same problem before with VBA.

I only use a few different colours, so I could just have a case statement to change the colour numbers if I'm using Excel 2010, but I'm hoping that there is a better way of doing this.
Any Ideas?

Thanks

Kristian