Problem with xlTextPrinter?

[NooK]

I am trying to save a excel document which contains data only in th
first column and each column is to be saved in a row in the tex
document, everything was working fine until I found that apparently i
the row ia too long if kind goes haywire.

Basically it breaks the rest of the row and puts 3 rows down from th
last row.

I cannot break the line, it has to be everything in the line.

I tried other text printing formats but it adds double quotes where i
is not supposed to.

Best Regards

Noo

 

[NooK]

Nobody.

Basically let's say the max is 7 characters (Of course the proble
occurs on 255 or something similar) and I have the rows in Excel wit
this data


ALEX
ALEXANDRE
M


What I get in the text file is:

ALEX
ALEXAND
ME

R


And as I said using other txt formats double quotes are added where i
is not supposed to, I want the text exactly how it writtne in Exce
(Thus xlTextPrinter, that is, prn file)

Hopefully someone can help me here.

Best Regards

Noo

 

[Dave Peterson]

After 240 characters is when the problem starts.

Maybe you could just copy and paste into NotePad and then save from there.

Or use a macro that creates the .prn file.

Maybe you can steal some code and create your own macro that does it:

Earl Kiosterud's Text Write program:
http://www.tushar-mehta.com/
Look for Text Write in the left hand frame.

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

 

[NooK]

Thanks that is exactly what I did (Paste to Notepad) by using SendKey
method.

It is a shame that Notepad can actually do this while Excel can't.

Thanks

Best Regards

Noo