Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I wonder if someone can help me with this.
I try to read from a text file with this piece of code; Do While Not EOF(1) 'Voer uit t/m de laatste regel van het file Line Input #1, strTemp 'Lees regel Cells(RowNdx, ColNdx).Value = strTemp 'schrijf regel naar Excel-sheet RowNdx = RowNdx + 1 'Volgende regel Loop (This file is 110 lines long). And so far is all going well. But now I have to write all lines to another file (some lines are modified). Unfortunately stops the writing at line 100. (Some characters at the end of line 100 are also missing). The row counting is going on until the first empty row in the excel sheet. I herefor use this code; Do While Not Cells(RowNdx, ColNdx) = "" 'Voer uit t/m de laatste met tekst gevulde regel van het file Print #1, Cells(RowNdx, ColNdx).Value 'schrijf regel naar file RowNdx = RowNdx + 1 'Volgende regel Loop I don't know why the Print #1-command suddenly stops writing to the file at line 100???? Can someone help me with this?? Thanks, Pieros. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
command line options/switches to print excel file | Excel Worksheet Functions | |||
command line options/switches to print excel file | Excel Discussion (Misc queries) | |||
how to print a sheet by command | Excel Discussion (Misc queries) | |||
How to format the extension less file to print with Dos's Print Command | Excel Discussion (Misc queries) | |||
Create command button to print multiple worksheets in a excel file | Excel Discussion (Misc queries) |