Chapter 9. Manipulating Data with VBA
When you’re given a workbook filled with data, you’re going to want to ask questions about the data. What is the sum of the sales for a day? Or a month? Or a year? How much time elapsed between a customer’s orders? And is the data you’re about to write to a text file in the proper format to be read into a database? You can answer all of these questions, and many more, using the text, number, and date/time processing functions available to you in Excel VBA.
In this chapter, you will learn how to do the following:
Prepare text strings for processing.
Concatenate, find, and modify strings.
Perform summary calculations on numerical data.
Make financial ...
Get Microsoft® Office Excel 2003 Programming Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
