Forum Discussion

Copper Contributor

Nov 29, 2021

Activeworkbook excel size

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.

Formulas and Functions

Silver Contributor

Nov 29, 2021

Sure: FileLen(ActiveWorkbook.FullName) gives the size of the file (in Bytes) as it was last saved

Copper Contributor

Nov 29, 2021

Thanks.