Microsoft Office 2000/Visual Basic Programmer's Guide

Working with Strings as Arrays

It may be hard to believe, but some of the most exciting new features in VBA in Microsoft Office 2000 are the new functions for working with strings as arrays. These functions can turn once-lengthy string-manipulation procedures into just a few lines of code. And in many cases, they're faster than using loops and string-parsing techniques to work with the contents of a very large string.

Note   If you're unfamiliar with arrays or you need a quick refresher course, see "Understanding Arrays" later in this chapter.