Text file created from Excel
 

I have data in Excel.

I have a program which reads the data, validates it against certain
equations, and writes out the error report in a text file.

I am able to do this far.

How do I put the page breaks in the text file programatically? Say, if the
line count is more than 60, I would like the program to skip page and write
out on a new page.

Can you pl help?

Murthy

Text file created from Excel
 

Add a character chr(12), either on its own line or perhaps like this

strLine61 = Chr$(12) & strLine61

Regards,
Peter T


"Murthy" wrote in message
...
I have data in Excel.

I have a program which reads the data, validates it against certain
equations, and writes out the error report in a text file.

I am able to do this far.

How do I put the page breaks in the text file programatically? Say, if
the
line count is more than 60, I would like the program to skip page and
write
out on a new page.

Can you pl help?

Murthy