View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dflayfield dflayfield is offline
external usenet poster
 
Posts: 3
Default Get File Size (Number of Bytes) of Active Workbook

I need to populate a cell with the current file size of the active workbook.
I have tried:

Function FileSize(I As Integer)
FileSize = ThisWorkbook.BuiltinDocumentProperties(I)
End Function

and called the function in the sheet with:
=FileSize(22) ' 22 being the code for "Number of Bytes"
I get a #VALUE! error.

But if I use:
=FileSize(3) '3 being the code for "Author"
it works properly.

Any ideas?

Thanks,
Dave