Batch convert .txt files to .xls

Hi all,

I have 48 text files that need converting to Excel.
The obvious answer found in most forums uses the following code:

Please Login or Register  to view this content.

The problem is this converts the text from the files in a single column of each excel workbook as opposed to distributed into columns.
Excel's Text Wizard sorts this problem for manual conversions, so using the macro recorder, I've identified a code for manual, correct conversion as :

Please Login or Register  to view this content.

Can someone please suggest a code which combines the two and allows me to convert all 48 .txt files into correctly formatted Excel files, please?

Thanks!!

Untested here :

Please Login or Register  to view this content.

https://stackoverflow.com/questions/...umns-using-vba

Thanks, but this still has the same problem. The excel files import all the .txt data into the 1st column of the excel files..
Attached is an example of the .txt files I'm working with

Here is a similar macro to yours that will distribute the data to different columns.
I agree with Marc L, you already have a macro to do what you are seeking ... why not use it ?

Please Login or Register  to view this content.