Importing text files
 

I did a search on the message board on this subject, but wanted to ask
another question in conjunction with what was asked. When importing a text
file using vb script, is there a way to set breaklines as well? I know
where they would go. I just dont know how I would manipulate the script to
set the breaklines where I want.

Importing text files
 

If you mean "page break" this is example that adds three:

Sub a()
Dim Cell As Range
For Each Cell In Range("A10,A15,A20")
Cell.PageBreak = xlManual
Next
End Sub


--
Jim Rech
Excel MVP
"Dominique Feteau" wrote in message
...
|I did a search on the message board on this subject, but wanted to ask
| another question in conjunction with what was asked. When importing a
text
| file using vb script, is there a way to set breaklines as well? I know
| where they would go. I just dont know how I would manipulate the script
to
| set the breaklines where I want.
|
|