Display File Size in Cell

[sachavez]

Excel 2007

Is there a formula or function that will display the file size in a selected cell?

Thanks

 

[Simon Lloyd]

You can create a UDF like this:

Function FileSize() As Variant
FileSize = FileLen(ActiveWorkbook.Name) / 1000000 & " Mb"
End Function

Then in your cell use: =FileSize()

 

[sachavez]

Thanks for the reply, Simon.

I am familiar with UDFs and installed the code and UDF as described. However, my result is #Value!.

Do you have any suggestions as to why I'm getting this result?

 

[yytsunamiyy]

FileLen() requires the full path - so you'll need

Function FileSize() As Variant
      FileSize = FileLen(ActiveWorkbook.[COLOR=red][B]FullName[/B][/COLOR]) / 1000000 & " Mb"
End Function

edit: mind you, FileLen will only return the file size before opening.

 

[sachavez]

Bingo!

That did it, yytsunamiyy!

Thanks for the quick response.

Steve