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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
Change font and/or font size in headers, footers and body via VBA 1
How do I find the currently selected Scenario? 4
Is active cell editable? 1
Only show currently active file icon 1
Excel How to activate already opend PDF file through VBA code 1
Compare two workbooks and hi-light matches 0
Run macro on all files in a specific folder 3

Back
Top