HI,

Can anyone tell what I'm missing to be able save an excel workbook to
text format using dts.


Excel_WorkBook.SaveAs "E:\EXcelData\rabbit.txt"

Which save's it fine , but I need to be able to set the format for this
to be done properly

Regards
Andrew

It is worth posting to an Excel newsgroup as well, as it has to do with the
Excel object model.
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/


"Schnof" <info (AT) schnof (DOT) co.uk> wrote