Hello everybody,
I have an annoying problems with Excel versions. I have Excel 2007 on my workstation, but I'm editing an old Ms Access Database who are calling an old version of Excel. I want to select the colors from my SeriesCollection, but the code I have seen for newer version isn't working for me in my old database. It's working well in Excel 2007 :
How can I do the same thigs as the following code in Excel 2002 ?
ActiveChart.SeriesCollection(1).Points(1).Interior.Color = RGB(200, 0, 0)
ActiveChart.SeriesCollection(1).Points(2).Interior.Color = RGB(0, 200, 0)
ActiveChart.SeriesCollection(1).Points(3).Interior.Color = RGB(0, 0, 200)
ActiveChart.SeriesCollection(1).Points(4).Interior.Color = RGB(200, 20, 34)
ActiveChart.SeriesCollection(1).Points(5).Interior.Color = RGB(54, 54, 200)
ActiveChart.SeriesCollection(1).Points(6).Interior.Color = RGB(34, 255, 200)
ActiveChart.SeriesCollection(1).Points(7).Interior.Color = RGB(200, 34, 0)
ActiveChart.SeriesCollection(1).Points(8).Interior.Color = RGB(1, 200, 1)
I've seen other examples, but so far none are working. I'll continue to search a solution.
Thank you !
Bookmarks