Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Large Text Files | Excel Discussion (Misc queries) | |||
Importing text-files | Excel Discussion (Misc queries) | |||
Importing Text Files | Excel Discussion (Misc queries) | |||
importing text files | Excel Programming |