View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
JH[_2_] JH[_2_] is offline
external usenet poster
 
Posts: 2
Default Program to resave a collection of .xls files into tab separated .t

I was hoping I could use the built in feature in Excel that allows
to Save As without reading and writing all of the records myself.

I saw some threads that indicated a method to do a Save As but I couldn't
find a define to indicate tab separated values.

Jeff
"AA2e72E" wrote in message
...
You can do this using an ADO (from VBA) recordset object and its
GetString()
method to write to TAB delimited files.