I am creating an excel report from within a DTS package using the ActiveX
script.

I have an excel file that contains column names across the top (A1:AB1). -- I
would like these to be bold.

Then from A2:wherever the data ends I would like to have different color
background on the alternating rows (if A2:AB2 is white, I'd like A3:AB3 to be
grey, and so on)

Does anyone have any code for this?
Thanks,
Ninel

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200604/1

Hello ngorbunov via SQLMonster.com,

This really isn't a job for DTS. I would have a macro in Excel handle this
as it is a UI thing and not really a data task.

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com