Form feed

[Andy]

Hi,

Sorry, I can't find this answer in the forum - I'm sure there's a simple answer to it.

I'm sending some output to a file "Printfile" and excel opens the file to view the output.

WRITE Printfile,"something"

If I wanted to insert a page break after the above line what do I use?

WRITE Printfile, ??

Thanks,
Andy.

[Brian]

I think it is 0xC

Brian

[Andy]

Thanks Brian,

That looks right according to the Internet, but now I have to find a way to send it to the file.

At the moment it's just displaying the value in Excel rather than forcing a page break.

tried:
WRITE Printfile," 0xC" and WRITE Printfile, 0xC ?

Thanks,
Andy.

[Brian]

Andy, try:

WRITE PrintFile,"\x0C"

Brian

[Andy]

Thanks Brian for all your help.

It seems it cannot be done (in excel), so I think I will have to do it the old way i.e. count the number of lines being printed to the page.

Anyway,
thanks again,

Andy.

[billhsln]

Check out the 'Conditional Page Breaks' section.

www.technosamrat.com/tips-tricks/some-useful-tips-for-excel-conditionally-formatting-rows-page-breaks-more/

This might do what you are looking for.

Bill

[Andy]

Sorry for the late reply,

Thanks, yes will have a look at it.

Thanks again,
Andy.