Convert a TXT in XLSX or XLSB without opening the file (VBA)

Good morning everyone,

I am trying to convert file that are in TXT into excel document.

Currently I do the following:

HTML Code: 

It works, but it is very slow! Would you know a way to convert these files without opening and saving each of them.

Any thoughts?

Thanks in advance for your time.
Phil

Thanks Naveed!

I works well. Do you know if there is a way to convert text to excel without using the methods workbook.open. My Data is very large and each time I open, save and close one file it takes a little while.
I have tried with the function "name file.txt as file.xls" but it does not work.

Thanks again for your example, I like the way you declare the workbook and worksheet as object. I need to do that more often. I tend to write the whole code everytime.

Thanks again.
-Phil

thanks Norie.

Yes I have and it works as well. But I was trying to find a way to convert the file without opening them. It seems that it s not possible.