Topic: Creating Macros

The following are additional topics related to the category listed above. A bracketed number after the topic indicates how many articles are related to that subject.

Tips, Tricks, and Answers

The following articles are available. Click the article's title (shown in bold) to see the associated article.

Can't Save a Macro If you can't save your macros for some reason, here's a few things to check out. Microsoft Word versions: 6 | 95 | 97 | 2000 | 2002 | 2003

Comparing Strings Macros often need to compare text strings in order to make some type of decision. If you don’t do the comparison properly, you may not get the desired result. This tip explains how you can confidently compare strings to reduce the chance for error. Microsoft Word versions: 97 | 2000 | 2002 | 2003

Continuing Macro Lines How to split up long lines in a VBA macro. Microsoft Word versions: 97 | 2000 | 2002 | 2003

Counting Open Document Windows When creating macros, it is sometimes necessary to know how many documents are open in Word. This is relatively easy to do using the Windows.Count property, but it can be more troublesome to figure out what is in each of those windows. Microsoft Word versions: 97 | 2000 | 2002 | 2003 | 2007

Debugging a VBA Macro How to get the bugs out of your macro. Microsoft Word versions: 97 | 2000 | 2002 | 2003

Debugging a WordBasic Macro How to get the bugs out of your macro. Microsoft Word versions: 6 | 95

Determining an ANSI Value Extracting the numeric code for a character. Microsoft Word versions: 6 | 95 | 97 | 2000 | 2002 | 2003

Determining If a Number is Odd or Even Odd and even numbers are used for lots of different purposes, and sometimes you need to know the status of a given number. This tip discusses a simple technique you can use in your macros to determine whether a particular number is odd or even. Microsoft Word versions: 97 | 2000 | 2002 | 2003

Determining the Upper Bounds of an Array Variable arrays are a mainstay in macro programming. This tip discusses how you can determine, programmatically, the largest element available for any array. Microsoft Word versions: 97 | 2000 | 2002 | 2003

Disk Full Errors When Saving Macros If you are in the process of upgrading your old WordBasic macros to VBA in Word 97, this tip can save you a lot of grief. Microsoft Word versions: 97

Dissecting a String When writing macros, you often need to slice and dice strings so you can determine their different parts. VBA provides three primary functions you use for this purpose, as described in this tip. Microsoft Word versions: 97 | 2000 | 2002 | 2003

Locating the My Documents Folder Your macro, in the process of working with user files, may need to figure out where the My Documents folder is actually located. Once you understand how to access the user profile information, the desired path is a snap to recover. Microsoft Word versions: 97 | 2000 | 2002 | 2003

Repeating in a VBA Macro How to loop through a complete document in your VBA macro. Microsoft Word versions: 97 | 2000 | 2002 | 2003

Repeating in a WordBasic Macro How to loop through a complete document in your WordBasic macro. Microsoft Word versions: 6 | 95

Running Macros from Macros Need to run one macro from within another macro? You can easily do it by using the Run method of the Application object, as described in this tip. Microsoft Word versions: 97 | 2000 | 2002 | 2003 | 2007

Saving Changes when Closing If you write a macro that makes changes to a document, you may want that macro to save those changes. There are several ways you can implement the proper code to do this, as described in this tip. Microsoft Word versions: 97 | 2000 | 2002 | 2003 | 2007

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, you won’t get the results you want. The information in this tip provides the answers, as well as a whole lot of different ways you can approach the problem. Microsoft Word versions: 97 | 2000 | 2002 | 2003 | 2007

Saving in Document Format from a Macro Saving a document in a different format is easy if you are manually using the Save As command. Saving a document in an existing macro, in the format you want, is a bit trickier unless you know how to use the SaveAs method, described in this tip. Microsoft Word versions: 97 | 2000 | 2002 | 2003 | 2007

Turning on Large Icons in a Macro Word includes the ability to display toolbar icons in two sizes: regular and large. You can turn on the large icons by using the Customize dialog box, as described in this tip. Microsoft Word versions: 97 | 2000 | 2002 | 2003

Understanding Precedence Macros often contain mathematical formulas, some of them quite complex. When a formula contains more than one operator (such as + or -), VBA needs to figure out in which order to perform the operations. Here's how it's done. Microsoft Word versions: 6 | 95 | 97 | 2000 | 2002 | 2003

Using Message Boxes Macros often use message boxes to communicate information and get simple feedback from users. This tip explains how you can add message boxes to your macro, including the use of specific icons in the message box and specific buttons for feedback. Microsoft Word versions: 6 | 95 | 97 | 2000 | 2002 | 2003

Writing a VBA Macro from Scratch One of the ways that you can create macros is to write them in the VBA Editor from scratch. This tip explains how you can easily do this. Microsoft Word versions: 97 | 2000 | 2002 | 2003

Writing a WordBasic Macro from Scratch Ever wonder how to create a WordBasic macro from scratch? It is easier than you think. Microsoft Word versions: 6 | 95

More Topics

Tips, Tricks, and Answers

Take Control!

Helpful Links

Great Info!

RSS Feeds