Program to resave a collection of .xls files into tab separated .txt files

J

JH

Would it be possible to write a vba or vb program that when executed would
resave
a list of .xls files into tab separated .txt files? Right now I do this
manually. I tried doing
a record/playback macro but that's not the way to go. Thanks very much for
any
assistance!

Jeff H.
jhoward1 [at] nc [dot] [rr] dot [com]
 
G

Guest

You can do this using an ADO (from VBA) recordset object and its GetString()
method to write to TAB delimited files.
 
J

JH

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

coverting all *txt files in a folder to formatted .xls files 2
Copy selected columns from .xls to a .txt file question 4
Open Text Files/Format/Save as .xls for multiple files. 9
Import of Multiple Text Files 1
Word macro to save files as .txt 2
Must convert 500+ xls files to txt (tsv) 1
XLS files link to XLA files 1
Importing Multiple Text Files 7

Top