Working with Strings as Arrays

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

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.