Thread: Workbook size?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Workbook size?

Look for FileLen in VBA's help to get the size of the file already saved to
disk.

MsgBox FileLen(ActiveWorkbook.FullName)

"Charlotte E." wrote:

When you right-click a workbook in windows, and select 'Properties' you can
see the size of the workbook in bytes.

Is it possible to get a workbooks size from within the workbook by VBA code?

TIA,


--

Dave Peterson