On my wintel pc, I get a carriage return/linefeed at that end of every
line--including the last.

Are you saying that you got extra characters or that you don't want those
characters at the end of the file?

And just curious, why wouldn't you want those last crlf at the end of the last
line?

monster wrote:

Dear All

I am completely stuck

PROBLEM
I have a prn file which on creation always has a carraige return
inserted after the last row.

At the moment I am using VBA to generate the prn file but manually
opening notepad and deleting the carraige return and then saving it
again as a prn within notepad.

QUESTION
Is there a way, using VBA, to open the prn within notepad and delete
the carriage return? It seems to be hard coded. I have read the prn
in to notepad a line at a time but the carriage return remains.

Any help greatly appreciated.

Monster

--
monster
------------------------------------------------------------------------
monster's Profile: http://www.excelforum.com/member.php...o&userid=24353
View this thread: http://www.excelforum.com/showthread...hreadid=379508

--

Dave Peterson