Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  DTS and Formatting Excel

Author  Topic  Dario Starting Member 1 Post Posted - 2007-06-21 : 15:02:46 Hi All, I am looking for the code that would be used in a dts (activex vb) to format excel cells. I know some of them like .ColumnWidth .Font.Bold and a few others, But I can't find those to change the type of the cell (text, number, etc) or to manipulate borders. If anyone has this list or knows where it is I would be very appreciative. Thanks in advance