Send Page Break to Excel

[Thadeus]

Hello all,
Is it possible to send a functional Page Break to Excel via the Export feature?

I am imagining something such as sending the ASCII CHR(013) or some such.... I've been trying, but with no success.

Thanks,
Thadeus
CR 8.0 and Excel 8

 

[synapsevampire]

chr(13) is a carriage return.

I tried chr(12) and it failed to do the job.

I recall using VBA to force pagebreaks in Excel, so you might do this afterwards using a macro.

Here's an example for use with sorted data:

http://www.exceltip.com/ng-88.html

-k