How to write data after changing Excel column order to a text file in VBA

view story

http://superuser.com – I would like to write to a text file from Excel, but the data order is different from the column order in Excel. For Example: Excel Column : Col1, Col2, **Col3**, Col4, **Col5** Text file : Col1, Col2, **Col5**, Col4, **Col3** Please help me to solve this problem. (HowTos)