Msgbox to display file size of an active workbook

Tanner_2004

Well-known Member
Joined
Jun 1, 2010
Messages
616
Hi Folks:

I have seen many version of this, but not this request

I was hoping to display the file size of an active workbook within a msgbx.

I do care about the size of each worksheet,; I was also hoping to name the path and workbook.


Thank you!
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
you could use:

Sub Fileproperties()
File1 = "Path\filename.extension" 'you enter the default here, or choose, thisworkbook
MsgBox "The Size of " & file1.fullname & " is " & FileLen(File1) & " bytes"
End Sub
 
Upvote 0
Thank you! I am giving it a try now. I am not sure exactly where to place "thisworkbook", but I will figure it out.

Thanks again!
 
Upvote 0
This is what I tried:

Sub Fileproperties()
File1 = "ThisWorkbook" 'you enter the default here, or choose, thisworkbook
MsgBox "The Size of " & File1.FullName & " is " & FileLen(File1) & " bytes"
End Sub

it didn't with or without the quotes. I will keep playing with it.
 
Upvote 0
Code:
Sub Fileproperties()
    File1 = ThisWorkbook.FullName
    MsgBox "The Size of " & File1 & " is " & FileLen(File1) & " bytes"
End Sub
 
Upvote 0

Forum statistics

Threads
1,213,561
Messages
6,114,312
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top