Vbs file end of stream

How can I detect the end of a text file EOF in vbscript? Ask Question. Asked 5 years, 3 months ago. Active 2 years, 3 months ago.

Viewed 3k times. Application" 'Bind to the Excel object objExcel. Add 'Create a new workbook. Worksheets Sheet 'Bind to worksheet. Range "A1:E1". Columns 5. AutoFit objSheet. Cells 1, 1. Cells 1, 2. Cells 1, 3. Cells 1, 4. Cells 1, 5. Cells r,c. Close objExcel. SaveAs strExcelPath objExcel. Quit I've written the code now in such a way that I do not get any errors. Improve this question.

Plus, you are adding the line in arrFileLines i but then reading from arrFileLines j , which might cause unpredicted issues. I would work with i or another better named variable for the arrFileLines and with j or, again, another better named variable for the a and avoid reusing the variables like this — Victor Moraes. Plus, your Redim Preserve arrFileLines 10 inside the loop is useless. For every iteration you are re-declaring arrFileLines with a dimension of 10 but keeping the existing data.

Thank you. Microsoft makes no warranties, express or implied, with respect to the information provided here. Reads a sequence of bytes from the current file stream and advances the position within the file stream by the number of bytes read.

The byte offset in array at which the read bytes will be placed. The total number of bytes read into the buffer. This might be less than the number of bytes requested if that number of bytes are not currently available, or zero if the end of the stream is reached. The following example reads the contents from a FileStream and writes it into another FileStream. This method overrides Read.

The offset parameter gives the offset of the byte in array the buffer index at which to begin reading, and the count parameter gives the maximum number of bytes to be read from this stream. The returned value is the actual number of bytes read, or zero if the end of the stream is reached. If the read operation is successful, the current position of the stream is advanced by the number of bytes read. If an exception occurs, the current position of the stream is unchanged.

The Read method returns zero only after reaching the end of the stream. Otherwise, Read always reads at least one byte from the stream before returning. If no data is available from the stream upon a call to Read , the method will block until at least one byte of data can be returned.

Frahaan Hussain. Previous Page. Next Page. Useful Video Courses. More Detail. Previous Page Print Page. Save Close. Drive Drive is an Object. Drives Drives is a Collection. File File is an Object.