PDA

View Full Version : Solved: File Property



anandbohra
10-17-2007, 12:13 AM
:hi: 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
10-17-2007, 12:29 AM
This works upon the last saved version, so best to save it first



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

anandbohra
10-17-2007, 12:48 AM
Thanks XLD
for such a quick & accurate response.
:clap: