Re: I Need VBA Assistance looking for End of a file

From: Myrna Larson (anonymous_at_discussions.microsoft.com)
Date: 02/26/05 

Date: Sat, 26 Feb 2005 12:46:55 -0600

Don't confuse EOF -- which refers to the end of a disk file -- with the end of
the data in a worksheet column.

On Fri, 25 Feb 2005 14:13:01 -0800, "Brent E"
<BrentE@discussions.microsoft.com> wrote:

>Good afternoon,
>
>I need to know a VBA command that will look at all cells in Column B until
>end of file or EOF. I tried DO UNTIL ... EOF, but didn't seem to work. Any
>suggestions? Thanks.

Relevant Pages

  • Re: Value of EOF
    ... refers to. ... Since I just read the parent article, ... And the answer to your question is no; EOF does not have the value 0 ... "Reply" at the bottom of the article headers. ...
    (comp.lang.c)
  • Re: read() and EOF
    ... situations where EOF is only returned once, ... disk file, this usually means ... If someone makes the file larger, a subsequent read will succeed. ... A readcall on a non-blocking file descriptor with no data available ...
    (comp.unix.programmer)
  • Re: read() and EOF
    ... there a guarantee that it will continue to do that on subsequent ... situations where EOF is only returned once, ... disk file, this usually means ...
    (comp.unix.programmer)
  • Re: Is it feasible to retry the read operations on OSS unstructure CSV (coma seperated value) files
    ... But if the file being read is a disk file that simultaneously is being extended by another program, I believe the reader will get an EOF whenever it catches up to the writer. ...
    (comp.sys.tandem)