| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Which version of Excel created the file | Excel Discussion (Misc queries) | |||
| Original Excel File gets deleted and temp file gets created. | Excel Programming | |||
| Saving multi-tab excel file created from comma delimited text file | Excel Programming | |||
| What version Excel file was created in. | Excel Programming | |||
| Excel Version in which file was created | Excel Programming | |||
Linear Mode
