Disk Full Errors When Saving Macros

by Allen Wyatt
(last updated February 22, 2009)

If you are a "macro maniac," and you are converting your macros to Word 97, you may run into a slight problem. When you save your newly converted macros to disk, you may get a disk-full error. (This occurs regardless of how much disk space you have available.) The reason for this is the length of the lines in the macros themselves. Under Word 95, which used WordBasic, there was no effective line length--Word took care of reformatting your macro lines to an acceptable length.

Under Word 97, there is essentially no limit on the line length, meaning that VBA won't reformat your lines--it leaves them as long as you enter them (or as long as the conversion process makes them). If you get the "disk full" error, look at your macros and shorten any long lines. If you get them fairly short (say, under 500 characters or so), and then try to save again, the error message should go away.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (114) applies to Microsoft Word 97.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He  is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Adding Borders to Cell Contents

Word allows you to quickly add borders to cells in a table, but you may not know that you can also add borders to the text ...

Discover More

Picking a Chart Type

Microsoft Chart offers several different types of charts you can use to display your data. Here's how to pick the type that ...

Discover More

Limiting Scroll Area

If you need to limit the cells that are accessible by the user of a worksheet, VBA can come to the rescue. This doesn't ...

Discover More

Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!

MORE WORDTIPS (MENU)

Saving in a Macro Using a Desired File Name

Need to save a new document, from within a macro, to a specific file name? If you use the Record Macro capabilities of Word, ...

Discover More

Controlling the Hidden Text Attribute

Want your macro to change the Hidden attribute for some text in your document? It's easier to change than you might think.

Discover More

Determining an ANSI Value

You may need to determine the numeric value of a character in a macro. You can do that using the Asc function, described in ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments for this tip:

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is seven minus 6?

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)


Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.

Links and Sharing
Share