Get value and color of cells with Access

[bamoo]

Hello
I would like to know how to get value and color of cells with Access ?
Thanks :-)

[Bob Phillips]

Hello
I would like to know how to get value and color of cells with Access ?
Thanks :-)

Do you mean from within Access?

This might get you started

Set xlApp = CreateObject("Excel.Application")
    Set xlWB = xlApp.Workbooks.Open("C:\myData\myExcel.xls")
    Set xlWS = xlWB.Worksheets("Sheet1")
    With xlWS.Range("A1")
         MsgBox .value
          MsgBox .Interior.ColorIndex
    End With

[bamoo]

Thanks. It's exactly what I wanted :-)