Excellent post, thanks so much.
Do you know what vba uses to define the end of the file? As it uses CR or CRLF to work out the end of line, is there a similar character it uses to define end of file?