Re: Need GetFileSize()

"Butch Meese" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Need a Excel macro function to get the size of a file.
> I have tried FileLen(), but does not seem to work.
> I will be using it on mp3 files (large).
>
> I first tried to get the size of a directory, but
> had no luck there either.
>
> Is this a case where I may need to do an add-on
> to get this to work?
>
> Thanks
> Butch Meese

There is a VBA function FileLen but no direct Excel function.
So you need to write your own function, e.g.

Function FileLength(ByVal A As String)
 FileLength = FileLen(A)
End Function

Apply it by writing the name of the file in A1 and Filelength(A1) in B1

--
Rommert J. Casimir
Tilburg University
P.O. Box 90513
NL 5000 LE Tilburg The Netherlands


"Butch Meese" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Need a Excel macro function to get the size of a file.
> I have tried FileLen(), but does not seem to work.
> I will be using it on mp3 files (large).
>
> I first tried to get the size of a directory, but
> had no luck there either.
>
> Is this a case where I may need to do an add-on
> to get this to work?
>
> Thanks
> Butch Meese
> [EMAIL PROTECTED]