Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get File Size (Number of Bytes) of Active Workbook
I need to populate a cell with the current file size of the active workbook.
I have tried: Function FileSize(I As Integer) FileSize = ThisWorkbook.BuiltinDocumentProperties(I) End Function and called the function in the sheet with: =FileSize(22) ' 22 being the code for "Number of Bytes" I get a #VALUE! error. But if I use: =FileSize(3) '3 being the code for "Author" it works properly. Any ideas? Thanks, Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
worksheet size in bytes | Excel Discussion (Misc queries) | |||
Reducing file size (for archiving, not active files) | Excel Programming | |||
I can't adjust the window size of an active workbook. | Excel Discussion (Misc queries) | |||
How to get the size of the excel file, a sheet size (in bytes)? | Excel Programming | |||
Determine active file size | Excel Programming |