How to Insert a Page Break (Using VBA)

[DevDaniel]

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]

Easier to insert it before, if you can deal with the superfluous break at
the start. Find: "Account:" Replace with: "^m^&"