Posted to microsoft.public.excel.programming

Edwin Niemoller[_2_] Edwin Niemoller[_2_] is offline

external usenet poster

Posts: 4

Supressing CHR13 or vbCr write in text file

Hello group,

2nd attempt different formulation

When writing a text file from VBA windows default ends a line with hex 0A
and 0D (LF an CR)

I need to prepare a UNIX format with only Hex 0A (linefeed) at the end.

Can this be done from VBA and thus not needing a conversion like UNIXtoDOS
afterwards?

Thanks for your thoughts

Edwin

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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
Load text file and write back	sanjay	Excel Programming	1	May 26th 04 03:28 AM
how to write other language in text file from VBA	Ravi	Excel Programming	1	January 27th 04 03:21 AM
write 1-dimensional array of integers to text file	RB Smissaert	Excel Programming	3	October 12th 03 05:56 PM
opening and write to a text file in excel	julian brotherton	Excel Programming	1	October 5th 03 11:13 PM
write a line from Excel to a text file	julian_bro	Excel Programming	1	September 30th 03 01:29 AM

All times are GMT +1. The time now is 11:23 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us