Automation to Excel - Setting "Interior.ColorIndex"

  • Thread starter Thread starter Bob Barnes
  • Start date Start date
B

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
 
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.
 
Back
Top