Hello:

I have about 1300 CSV files that are all exactly formatted the same
and named similarly i.e. Bom1.txt, Bom2.txt., etc. I want to convert
each .txt file into an .xls file. Is there a way to do this by either:

1. Creating a macro to convert the .txt file to a .xls file. OR

2. Using VBA to batch convert several .txt files to individual .xls
files. OR

3. Using VBA to batch convert several .txt files to individual sheets
in a single .xls file.

The .xls files could be saved with the same name as the .txt files in
the same directory.

Appreciate your help.

"Pigs can't be humans, but humans can be Pigs!"

Eating at the trough of life.

Oink!

SowBelly