Text file created from Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Add a character chr(12), either on its own line or perhaps like this

strLine61 = Chr$(12) & strLine61

Regards,
Peter T
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a Text file from Excel 3
CreateTextFile method - Pagebreaks in the Text file 5
VBA Read-Manipulate-Save Text File 5
Stop Excel From Formating Text Starting with A Zero 5
how to separate text and numeric data in the excel or text file. 2
Save as Text 1
Trying to get just part of an XML file? 5
How open notepad.exe and write text line by line via excel vba? 2

Back
Top