Problem with xlTextPrinter?

N

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
 
N

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
 
D

Dave Peterson

N

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
 
Top