.txt files (delimiter: comma) into .xls or .xlsx file

Hi All,

I have code written to open a single .txt file (attached), format it using comma as delimiter and save it as either .xls or .xlsx file.

I need to open multiple files like this. Right now I go back to vba editor, copy the below code, paste it multiple times and only change the name of the .txt file.

Could anyone help me how I can do the above operation using a simpler code?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

if problems attach a sample text file