Thread
:
Determine active file size
View Single Post
#
2
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
Determine active file size
Try something like
Debug.Print FileLen(ActiveWorkbook.FullName)
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"pk" wrote in message
...
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.
Reply With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson