Create text file using VBA from Excel Tabular data

Greetings to All,

Hope all are great and fine.

I have a request regard to create text file using vba macro from using Excel sheet data's.

I request you all and help me on this to move forward.

Here is an Example:

EXCEL.png

FileName - Need to create text file in this name.
Line 1 to 6 - need to write line by line in each text file.

Kindly review my consideration and do the needful.

Thanks

Great !!!

It works perfect.