OWC11 problem with .Interior.Color

[Nicolas Tostin]

Hi,
I just set up OWC11 on my IIS6, and my script to generate Excel files seems
to works fine but th funcion .Interior.Color doesn't seems to work....

here is my code :
objSpreadsheet.Range("A1").Interior.Color = RGB(255,0,0)
or
objSpreadsheet.Range("A1").Interior.ColorIndex = 3

My cell stay deseperatly white....

Any ideas ?

Thanks a lot

Nicolas

 

[Alvin Bruney [MVP]]

the color property takes an object if memory serves me correctly. you may
want to try
..Color = "red";
or .Color = (object)"red"; if you are anal about syntax.