Create a Text file from Excel

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

Guest

I am trying to create a report, in text format from Excel.

So far I have been successful in creating an object, and put the records
line by line with WriteLine method.

In text-based reports, the common requirement is putting headers, footers,
and more importantly, setting the number of lines per page. I used a line
counter in my program.

What I need to know is:

1. How will I tell Excel to put a page break in the text file being created?

2. How will I tell Excel to make some headings bold? or Underlined?

Murthy
 
Plain text has no line breaks or formatting.
If you need that kind of report you'll have to use a different format, such as maybe HTML or Word.
 
I bet you meant that plain text files don't have page breaks.

Line breaks are pretty common in text files <bg>.
 

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

Text file created from Excel 1
How write into text file at first and last line with excel vba? 3
CreateTextFile method - Pagebreaks in the Text file 5
Word to Excel: Export comments with text and line number 0
Text To Column max 26 characters 7
Excel 2003 get text after wraptext problem 3
Word Removing unwanted "lines" within a MS Word 10 table 1
Run an external bat file from inside VBA 2

Back
Top