Determine active file size

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.
 
C

Chip Pearson

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)
 

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

New computer, how do i move outlook 365 ENTIRELY? 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Word 2013 field code Nested IF statement 1
Help required re Activation of Office 1
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
VBA Coding Help for Beginner 0
Run macro on all files in a specific folder 3
Change font and/or font size in headers, footers and body via VBA 1

Top