The Print # command print not all rows from excel sheet to file
NickHK I'm sorry but when I use this code
Option Explicit
'*********************** Programma schrijft alleen de 1e 100 regels
naar het aangegeven file - de laatste regel niet helemaal compleet
??????? **
Sub read_file()
Dim InFile As Long
Dim OutFile As Long
InFile = FreeFile
Open "U:\Programs - Documents\MSExcel\Test zoek en vervang 4 -
aangepast volgens
forum\Approved\Cop00004500\00004583_001_KART_KM9_V 1.xml" For Input As
#InFile
OutFile = FreeFile
Open "U:\Programs - Documents\MSExcel\Test zoek en vervang 4 -
aangepast volgens
forum\Corrected\Cop00004500\00004583_001_KART_KM9_ V1.xml" For Output As
#OutFile
Print #OutFile, Replace(Input(LOF(InFile), #InFile), "1LS-Arial",
"1LS-OCR-B-10 BT")
Close #InFile
Close #OutFile
End Sub
I get the Run-time Error 62 again. (Input past end of file)
My text replacement wish is not a simple one I believe.
Pieros
|