Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 53
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Issue writing IF OR Error Formula Types lozzam New Users to Excel 1 October 26th 06 08:14 AM
File conversion-text encoding issue elhirsch Excel Discussion (Misc queries) 2 September 11th 06 03:19 PM
writing on an excel file RITZ New Users to Excel 3 September 2nd 06 09:44 PM
"Small" Multi-Dimensional Array Slow Writing To Cell Steve Hieb Excel Programming 2 September 6th 03 03:20 AM
Writing multilines to a text file without closing ccdubs Excel Programming 1 July 10th 03 07:43 AM


All times are GMT +1. The time now is 02:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"