Hepl for convert txt file to excel using vba sub

Halo everyone,
I have problem when open the txt file.
This is some steps I use to open txt file:

open excel application
step 1: File --> Open --> open txt file

step 2: in "Text inport wizard" step 1 of 3 window
- Choose the file type that best describes your data: choose "Delimited"
- srat import at row: 1
- File origin: 65001: Unicode (UTF-8)

step 2: in "Text inport wizard" step 2 of 3 window
- Delimiters: tab
- Text gualifier: {none}

step 3: in "Text inport wizard" step 3 of 3 window
- Choose all data record in "Data preview"
- Column data format: text
- Finish

step 4 ---> file --> save as --> convert to xls type.

I want to convert steps above to vba code. When run vba code, my txt file will automatically convert to txt file.

So this is something i want:

Input: the path contains 1 or more txt file.

Output: the excel file with same name with txt file and Delimiters, Text gualifier, Column data format...... same steps above.

Please check attachments file. That is a sample, it has only 4 columns, actually, my txt file has 100 or more columns.

Thanks all and best regards.