I have: a fixed width text file
I want: to insert a page break after each account listing, using VBA
Sample file:
Account: 1000 Date: July 31, 2006
Statement Month: July 2006
Trans Date Description Amount
------- ---------------- --------------------------- ----------------
0035 07/01/2006 apples, crate 199.99
0064 07/05/2006 bananas, crate 58.00
Account: 1001 Date: July 31, 2006
Statement Month: July 2006
Trans Date Description Amount
------- ---------------- --------------------------- ----------------
0587 07/01/2006 grapes, crate 120.00
0952 07/05/2006 orange juice, 64L 60.00
0587 07/26/2006 kiwi, crate 200.00
...
Jezebel - 31 Jul 2006 23:13 GMT
Easier to insert it before, if you can deal with the superfluous break at
the start. Find: "Account:" Replace with: "^m^&"
>I have: a fixed width text file
>
[quoted text clipped - 18 lines]
>
> ...