VBA Developer's Handbook
Chapter One
Manipulating Strings
* Understanding how string values are stored and
used in VBA
* Using the built-in VBA string-handling functions
* Searching for and replacing text
* Gathering information about strings
* Converting strings
* Working with substrings
Almost any VBA application will need t o handle string (text) data at one
point or another. VBA itself provides a useful set of string-handling functions, but
the functionality of other functions as a whole is not nearly as full-featured as that
provided by other, more text-centric programming languages. This chapter first
makes a quick pass through the existing functions and then provides many useful
routines to add to your string-handling bag of tricks. Surely, no chapter on this
topic could cover every possible combination of useful functions, but the ones we've
provided here should give you a good start in writing your own VBA solutions.
The sample files you'll find on the CD-ROM that accompanies this book are
listed in Table 1.1:
WARNING
Because the modules for this chapter take advantage of ADO, you'll need to make
sure your own project includes a reference to t ... read full excerpt from VBA Developer's Handbook ebook
