Solved: File Property

[anandbohra]

Friends

do any one of you have code for getting file size in one click
Say i press a button or execute a macro thorugh Key board code & it displays the message
Active File Name: (file Name)
File Size : ( XXX MB)

This i need because i make the Master file which is linked to 3-4 workbooks so I want myself to be update on file size otherwise it will slow down my work insted of speed up

[Bob Phillips]

This works upon the last saved version, so best to save it first

[vba]

Set wb = Workbooks("workbook_name.xls")
MsgBox Format(FileLen(wb.FullName), "#,##0,Kb")
[/vba]

[anandbohra]

Thanks XLD
for such a quick & accurate response.