Automation to Excel - Setting "Interior.ColorIndex"

[Bob Barnes]

I'm running this code within Access, during automation to Excel...
.....
objXLSheet.Range("ETwelve").Interior.ColorIndex = 38
....but it does NOT retain that Interior.ColorIndex when
opening the Excel file.

I can assign values, thru automation, to Excel, that if there, will assign
the Interior.ColorIndex during Workbook_Open.

I have NOT entered this in the Excel Newsgroup...yet, and may not,
but instead go with the paragraph above.

Does any one know how to get "Interior.ColorIndex"
automation code (or something similar) to get that
to work in Excel when the Workbook is opened?

TIA - Bob

 

[Bob Barnes]

I wound up doing..
..Interior.Color
in Workbook_Open, after....from below...
....I can assign values, thru automation, to Excel, that if there, will assign
the Interior.Color during Workbook_Open.

Works great.