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?

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?

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?

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..