>My application creates an Excel file. I need to make the 1st row of information in the Excel file appear yellow. I tried the following (for each cell):
>
Hi There:)
If you are making complex excel sheet, rather then directly coding
OLE automation, you can have look at mine 'rep2excel' tool here in downloads.
It is based on simple class wrapping cumbersome automation code pieces
for common automation calls into one line calls.
Coloring u wanted could be done by call like;
oXl.paint_box(1,1 , 1,50, 6)
and meny more things like, writing arrays, tables
drawing boxes lines inserting pictures, writing grouped reports etc.
Rgds++