Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing a text file from Excel using VBA ... a small issue
I have written a small app the writes flat text files from excel (order/routing tickets) and sends them to various different printers around this place.. it is pretty simple and uses the Open strfilename For Output Access Write Lock Write As #1 Print #1, " This is where the text goes" & string & "" formats... I've just been asked to Bold some of the fields...I don't think that is possible but I can't find any real info... can someone tell me for sure yes or no? Please? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing a text file from Excel using VBA ... a small issue
No,
Text files (open with notepad) have no formatting. Dan E "ajames54" wrote in message ... I have written a small app the writes flat text files from excel (order/routing tickets) and sends them to various different printers around this place.. it is pretty simple and uses the Open strfilename For Output Access Write Lock Write As #1 Print #1, " This is where the text goes" & string & "" formats... I've just been asked to Bold some of the fields...I don't think that is possible but I can't find any real info... can someone tell me for sure yes or no? Please? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing a text file from Excel using VBA ... a small issue
Its not possible. When you are writing basic text format files,
you can't use any sort of formatting like bold or italics. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "ajames54" wrote in message ... I have written a small app the writes flat text files from excel (order/routing tickets) and sends them to various different printers around this place.. it is pretty simple and uses the Open strfilename For Output Access Write Lock Write As #1 Print #1, " This is where the text goes" & string & "" formats... I've just been asked to Bold some of the fields...I don't think that is possible but I can't find any real info... can someone tell me for sure yes or no? Please? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing a text file from Excel using VBA ... a small issue
On Wed, 3 Dec 2003 06:57:19 -0600, "Chip Pearson"
wrote: Its not possible. When you are writing basic text format files, you can't use any sort of formatting like bold or italics. My thanks to both of you.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Issue writing IF OR Error Formula Types | New Users to Excel | |||
File conversion-text encoding issue | Excel Discussion (Misc queries) | |||
writing on an excel file | New Users to Excel | |||
"Small" Multi-Dimensional Array Slow Writing To Cell | Excel Programming | |||
Writing multilines to a text file without closing | Excel Programming |