If your .txt files are all in a single folder (and there's no .txt files that
shouldn't be merged together), maybe you could use Ron de Bruin's code:

http://www.rondebruin.nl/csv.htm

It actually looks for .csv files, but you could change that to .txt.

ajocius wrote:

Group,
I'm not sure if I should break this up or just ask for the whole
enchilada. I'll start with the big picture. I want to launch a macro
that will review all text files in a directory. If the file is <= 500
bytes, delete it. If its greater than 500 bytes, starting parsing the
file. I want to have a single file, lets call it the master file
(Excel) which will take parts of the text file(s) and log what is being
copied from the text file. So my questions a
1. Can I delete files from within a spreadsheet? If so, how can I
do it?
2. Can I append to an Excel file based on data found in multiple
text files, each with a different name and potentially 1000's of text
files?

We test radios and each radio has a unique data file. The data is
saved in text with each file having a unique name to it. I want to
combine all the files into a master file. Later we analyize the data.
Your thoughts on how I should approach this macro. I want to do this
in VBA for Excel.

Tony

--
ajocius
------------------------------------------------------------------------
ajocius's Profile: http://www.excelforum.com/member.php...o&userid=17695
View this thread: http://www.excelforum.com/showthread...hreadid=497295

--

Dave Peterson