<div>
Hi AlexF777,<br />
&nbsp; &nbsp; Flat file means? Text file? or another Excel sheet? Do you want it to be done in VBA?<br />
&nbsp; &nbsp; <br />
Do this...<br />
&nbsp; &nbsp; Goto Excel --&gt; Insert --&gt; Worksheet.<br />
&nbsp; &nbsp; In the new sheet..<br />
&nbsp; &nbsp; A1 = Sheet1!A1 &amp;&nbsp;Sheet1!A3 &amp;&nbsp;Sheet1!A5<br />
&nbsp; &nbsp; B1 = Sheet1!A2 &amp;&nbsp;Sheet1!A4 &amp;&nbsp;Sheet1!A6<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; Now copy both the formulas to the bottom to all the rows where you have data.<br />
&nbsp; &nbsp; Select both the columns and copy.<br />
&nbsp; &nbsp; Goto a text editor like notepad or wordpad and paste.<br />
<br />
Bye<br />
---<br />
Harish
</div>


Hi AlexF777,
    Flat file means? Text file? or another Excel sheet? Do you want it to be done in VBA?
   
Do this...
    Goto Excel --> Insert --> Worksheet.
    In the new sheet..
    A1 = Sheet1!A1 & Sheet1!A3 & Sheet1!A5
    B1 = Sheet1!A2 & Sheet1!A4 & Sheet1!A6
   
    Now copy both the formulas to the bottom to all the rows where you have data.
    Select both the columns and copy.
    Goto a text editor like notepad or wordpad and paste.

Bye
---
Harish

<div>
elaborate the question..<br />
<br />

</div>


<div>
 &nbsp; &nbsp; Flat file means text file.<br />
&nbsp; &nbsp; &nbsp;I want it done in VB.<br />
&nbsp; &nbsp; &nbsp;Not manually.<br />
<br />
For example: &nbsp; &nbsp;Col1 &nbsp;Col2 &nbsp;Col3 &nbsp;Col4 &nbsp;Col5 &nbsp;Col6 <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A &nbsp; &nbsp; &nbsp;B &nbsp; &nbsp; &nbsp; C &nbsp; &nbsp; &nbsp;D &nbsp; &nbsp; &nbsp; E &nbsp; &nbsp; F<br />
Would give me a flat text file with <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A &nbsp; &nbsp; &nbsp;B<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C &nbsp; &nbsp; &nbsp;D<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;E &nbsp; &nbsp; &nbsp; F<br />
<br />
<br />
<br />
<br />

</div>


    Flat file means text file.
     I want it done in VB.
     Not manually.

For example:    Col1  Col2  Col3  Col4  Col5  Col6
                         A      B       C      D       E     F
Would give me a flat text file with
                         A      B
                         C      D
                         E       F






<div>
<div class="content wysiwyg-content">
I would like to have a flat file with 2 columns, where <br />
<br />
column1 would contain Excel cols 1,3 and 5<br />
column2 would contain Excel cols 2,4 and 6<br />
<br />
Thanks in advance<br />
<br />
<br />

</div>
</div>


I would like to have a flat file with 2 columns, where 

column1 would contain Excel cols 1,3 and 5
column2 would contain Excel cols 2,4 and 6

Thanks in advance




I have Excel spreadsheet with 6 columns and unknown # rows

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.