Solved: Detect File Size through VB

[jtrowbridge]

I'm trying to figure out how to determine the size of a file through VB. I found some code on Microsofts website but its bombing out. Here's what i got:

Dim infoReader As System.IO.FileInfo
infoReader = My.Computer.FileSystem.GetFileInfo("C:\test\test.txt")
MsgBox ("File is " & infoReader.Length & " bytes.")


I ultimately want to pass the current size of a file into a variable so that i can check the size over time.

Any ideas?

[Bob Phillips]

How about Filelen

[vba]

Debug.Print FileLen("C:\test\ADO Test.xls")
[/vba]

[jtrowbridge]

Works perfectly. Thanks!