Activeworkbook excel size

Copper Contributor

Hello,

It is possible to get the size of the excel active workbook as the value of a variable in a instruction visual basic.?

Thanks.

 

3 Replies
Sure: FileLen(ActiveWorkbook.FullName) gives the size of the file (in Bytes) as it was last saved
Thanks.
I AM NO SURE.
Look at the case, if you only edit a macro to change a value 123 to 456 and then you save the file, normaly the file size change "ramdomly".
So, why ?.
More, sometimes if you open the file and inmediately save as with another name the size change.
May you test it ?
So, the value of the function is not stable, and you can not determinate if a file was modify or not, because the secuence: open and save change the value.
Greetings.