View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
monster monster is offline
external usenet poster
 
Posts: 1
Default Prn file carriage return deletion within notepad


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