Determine active file size

  • Thread starter Thread starter pk
  • Start date Start date
P

pk

Please help!

I am using VBA in Excel XP with Windows 2000.

Could someone please provide me with the code required to
determine the size of the currently open and active Excel
file in bytes?

Thanks much in advance for your assist.
 
Try something like

Debug.Print FileLen(ActiveWorkbook.FullName)



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
Back
Top