ExcelBanter - How to get the size of the excel file, a sheet size (in bytes)?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How to get the size of the excel file, a sheet size (in bytes)? (https://www.excelbanter.com/excel-programming/289348-how-get-size-excel-file-sheet-size-bytes.html)

bookworm98[_13_]

How to get the size of the excel file, a sheet size (in bytes)?

I want to calculate how many bytes in one sheet, the size of a excel
file(in bytes)
Is there any functions to get them?
Thanks

---
Message posted from http://www.ExcelForum.com/

BrianB

How to get the size of the excel file, a sheet size (in bytes)?

Only the workbook size (from file on disk)

MsgBox (FileLen(ActiveWorkbook.FullName)

--
Message posted from http://www.ExcelForum.com

All times are GMT +1. The time now is 03:03 AM.