Chapter 9: Manipulating Data with VBA

 < Day Day Up > 



Overview

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 decisions using Excel calculations.

  • Work with dates and times in Excel.



 < Day Day Up > 



Microsoft Excel 2003 Programming Inside Out
Microsoft Office Excel 2003 Programming Inside Out (Inside Out (Microsoft))
ISBN: 0735619859
EAN: 2147483647
Year: 2006
Pages: 161

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net