LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
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
Carriage return CWH Excel Discussion (Misc queries) 1 March 16th 10 01:54 PM
how to copy excel carriage return to notepad w/out the quotations BB Excel Worksheet Functions 4 July 10th 08 06:52 PM
Excel import txt file carriage return as delimiters Gordo T Excel Discussion (Misc queries) 5 August 2nd 06 01:55 PM
carriage return that works when pasted into a text file (eg. Notep Chris Glen Excel Discussion (Misc queries) 3 February 14th 06 03:01 AM
Carriage Return Tom Ogilvy Excel Programming 3 August 20th 03 07:22 PM


All times are GMT +1. The time now is 06:50 PM.

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

About Us

"It's about Microsoft Excel"