Find the Length of a Text File

[Dan R.]

I always use this to find the length of a text file but isn't there a
better way?

While (EOF(1) <> True)
Input #1, ' text
count = count + 1
Wend

Thanks,
-- Dan

 

[Guest]

Use the LOF command?

 

[Rick Rothstein \(MVP - VB\)]

I always use this to find the length of a text file but isn't there a

better way?

While (EOF(1) <> True)
Input #1, ' text
count = count + 1
Wend

Count = FileLen("<<path to your file>>")

Rick

 

[Dan R.]

I think LOF returns the file size in bytes... but I could be wrong...

Thanks,
-- Dan

 

[Dan R.]

That worked... thanks Rick.

-- Dan