If the text files are all the same, you could record a macro that Opens, saves
as an excel file, and closes the file.
Then that recorded macro could be modified to open all the text files in the
If the files vary in format, then maybe you could have different macros for each
type of text file.
Ron de Bruin has some code for working with CSV files that may be a good
(look for CSV)
If you need help tweaking your code, post back with your code and the version of
excel you're using--and the type of excel file you want to saveas.