vb.net data: Is there a good reference on the Excel Object in VB.NET? I can create the
object, send data to a sheet, open, save & print files, but I want to format
the cells (border, shading, font, merging, etc.). So far I haven't been
able to figure that part out. Any help is appreciated. Thanks!

Terry:

Select a range that you want to format ie Range("A1:A5").Select

Then use whatever formatters you need.
[quoted text, click to view]

[quoted text, click to view]

¤ Is there a good reference on the Excel Object in VB.NET? I can create the
¤ object, send data to a sheet, open, save & print files, but I want to format
¤ the cells (border, shading, font, merging, etc.). So far I haven't been
¤ able to figure that part out. Any help is appreciated. Thanks!
¤

Using the Macro Recorder in Excel can help you generate some of the code you need.


Paul ~~~ pclement@ameritech.net