Written by Allen Wyatt (last updated December 25, 2021)
This tip applies to Word 2007, 2010, 2013, 2016, 2019, and 2021
One of the nice things about writing macros is that you have the ability to do just about anything you can do using the regular Basic language. For instance, you may want to open and process some text file within a macro. Before doing so, you might want to know how large that file is.
You can figure this out using the FileLen function in VBA. It returns the length of a specific file, in bytes. You don't even have to open the file first; just provide a file name, and FileLen does the rest. The following is an example:
lFLen = FileLen("TargetFile.txt")
This code determines the length of the TargetFile.txt file and assigns that value to lFLen. The value returned is a long integer.
Note:
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (13209) applies to Microsoft Word 2007, 2010, 2013, 2016, 2019, and 2021. You can find a version of this tip for the older menu interface of Word here: Determining the Size of a File.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 365 applications with VBA programming. Written in clear terms and understandable language, the book includes systematic tutorials and contains both intermediate and advanced content for experienced VB developers. Designed to be comprehensive, the book addresses not just one Office application, but the entire Office suite. Check out Mastering VBA for Microsoft Office 365 today!
Inserting a break in your document is easy. You may think that inserting one using a macro is more complex, but it isn't. ...
Discover MoreUsing a macro to format your document (or portions of your document) is not all that uncommon. If you want your macro to ...
Discover MoreOne of the common things done in macros is to somehow "process" documents, which often means moving the insertion point ...
Discover MoreFREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.
Visit the WordTips channel on YouTube
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments