Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Program to resave a collection of .xls files into tab separated .txt files
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] |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Program to resave a collection of .xls files into tab separated .t
You can do this using an ADO (from VBA) recordset object and its GetString()
method to write to TAB delimited files. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare two files and update data from another file base on words ina cell separated by commas | Excel Worksheet Functions | |||
XLS Files Default Program | Excel Discussion (Misc queries) | |||
Problem with exporting xls sheels to txt files separated by tabs | Setting up and Configuration of Excel | |||
User Interface for Viewing a Collection of Data Files | Excel Programming | |||
Program Files Folder | Excel Programming |