DTS and macro excel

hi,
I have already set up a DTS package to convert my data to an excel file and I would like to alter the format of my data through my DTS without having to write a macro.
Do you know how to do this?need more details.|||From the DTS I get a plain text in my excel sheet. I have written a macro that takes all the sheets in the workbook and converts the first line of every sheet. The formating is to put a background color to and just make the cells and bit bigger.

Thanks a lot