Importing text files

  • Thread starter Thread starter Dominique Feteau
  • Start date Start date
D

Dominique Feteau

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.
 
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
|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.
|
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top