Creating Page Break in Print Statement

[Nigel]

I am extracting data from a worksheet to a text file using a series of print
statements.

I am using vbCrLf to insert line breaks, how do I insert a page break ?
Although the target file is a text file it will finally be opened in Word
and I need the page breaks to create the pagination. Currently I insert a
dummy character string and use the Word Find and Replace to insert the page
breaks, but this is not ideal.

TIA

 

[Dave Peterson]

You could try hex-0C (chr(12) in code).

I am extracting data from a worksheet to a text file using a series of print
statements.

I am using vbCrLf to insert line breaks, how do I insert a page break ?
Although the target file is a text file it will finally be opened in Word
and I need the page breaks to create the pagination. Currently I insert a
dummy character string and use the Word Find and Replace to insert the page
breaks, but this is not ideal.

TIA

 

[Nigel]

Thanks Dave that does the trick