Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a Text file from Excel
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a Text file from Excel
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. -- Tim Williams Palo Alto, CA "Murthy" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a Text file from Excel
I bet you meant that plain text files don't have page breaks.
Line breaks are pretty common in text files <bg. Tim Williams wrote: 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. -- Tim Williams Palo Alto, CA "Murthy" wrote in message ... 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a Text file from Excel
Err... yes - I did mean page breaks.
Thanks for the catch. -- Tim Williams Palo Alto, CA "Dave Peterson" wrote in message ... I bet you meant that plain text files don't have page breaks. Line breaks are pretty common in text files <bg. Tim Williams wrote: 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. -- Tim Williams Palo Alto, CA "Murthy" wrote in message ... 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a UTF-8 text file from excel VBA | Excel Discussion (Misc queries) | |||
Help - Can Excel create a text file?? | Excel Programming | |||
Can I use Excel to create this text file? | Excel Worksheet Functions | |||
How to create text file from selected excel data | Excel Programming | |||
Create and write a simple text file in Excel/VBA | Excel Programming |