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
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