Chart Line Colors

I'm writing some code in Access 97 that produces charts in Excel 2002. I can get the marker colors OK

objExcel.ActiveChart.SeriesCollection(1).MarkerForegroundColor = RGB(r, g, b)

but I can't get the line colors.

My chart type is LineMarkers

objExcel.ActiveChart.ChartType = xlLineMarkers

Anyone know how to set the line colors?

I ran the macro recorder to try and answer your Q. The ColorIndex property seems the probable suspect

    ActiveChart.SeriesCollection(1).Select
    With Selection.Border
        .ColorIndex = 51
        .Weight = xlThin
        .LineStyle = xlContinuous
    End With
    With Selection
        .MarkerBackgroundColorIndex = xlNone
        .MarkerForegroundColorIndex = xlNone
        .MarkerStyle = xlNone
        .Smooth = False
        .MarkerSize = 17
        .Shadow = False
    End With

I tried the same thing. Really sorry I didn't mentioned it. The problem with the ColorIndex property is that I don't know how to get RGB converted to ColorIndex. So maybe I should go the other way and use the macro recording feature to get the ColorIndex value just right. I was hoping to set both the markers and the lines using the same value system.

Thanks

Here's what I did:

                      .SeriesCollection(1).MarkerForegroundColorIndex = intColorIndex
                      .SeriesCollection(1).MarkerBackgroundColorIndex = intColorIndex
                      .SeriesCollection(1).Border.ColorIndex = intColorIndex

Thanks for the suggestion.