Hi,

Someone I know is making a VB script for Excel. The script allows him to add data to a spreadsheet, then go to the next line of te spreadsheet, add more data, and on and on.

The problem is that, when he outputs to a text file, the output file has 1 or 2 blank lines at the end, and the program this text file is going into doesn't like blank lines.

Is there any way to remove blank lines from the end of a file in vb once the file is created?

thanks