Please Note: This article is written for users of the following Microsoft Word versions: 97, 2000, 2002, and 2003. If you are using a later version (Word 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Word, click here: Determining the Size of a File.
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 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:
Please Note:
This article is written for users of the following Microsoft Word versions: 97, 2000, 2002, and 2003. If you are using a later version (Word 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Word, click here: 
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 (820) applies to Microsoft Word 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Word (Word 2007 and later) here: Determining the Size of a File.
Do More in Less Time! Are you ready to harness the full power of Word 2013 to create professional documents? In this comprehensive guide you'll learn the skills and techniques for efficiently building the documents you need for your professional and your personal life. Check out Word 2013 In Depth today!
If you develop a macro to process your document, you may want the macro to save the document to disk. This is easily done ...
Discover MoreWhen you process a document in a macro, you may also want to print that document from within the same macro. Here's how ...
Discover MoreWhen working with macros, you can often speed up processing by turning off the updating of the screen. Best news is that ...
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 menu interface (Word 97, Word 2000, Word 2002, or Word 2003)? This site is for you! If you use a later version of Word, visit our WordTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2019 Sharon Parq Associates, Inc.
Comments