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 ...
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.
