Is there a way to out put data from Excel into Text with column
oriented data format using VBA? For example, i have 50 rows and 8
columns and i need to write data in cell A to write at the 1st position
in the text file. Data from cell B to write at the 16th position in the
text file, etc. I know that we can set this up from Access db by
recordset, but how do we do this in VBA or VB?

Thank you for any help.