I wrote this book because I??™ve always enjoyed writing applications in Excel when it is the
required solution. Excel is often overlooked in coding situations, but as you??™ll see in the pages
of this book, it has many, many possibilities, and it is relatively easy to learn. Excel 2007 has
expanded XML support. XML data is easily brought into and out of an Excel project so your
client spreadsheet data can be shared. Excel UserForms give you the ability to create simple
user interfaces for your clients and allow you to create easy-to-use data collection tools. Excel
charting and PivotTables have always been a strong suit for data summary, and in Excel 2007,
PivotTables are greatly enhanced.
This book also addresses object-oriented programming to a great degree. Just because
you??™re not writing a .NET or even a classic Visual Basic application, there??™s no reason you can??™t
use object-oriented coding techniques in your projects. It provides you with the same advantages
in Excel that you get in the full-fledged programming languages: ease of reuse, easier
code maintenance, encapsulation, and more.
You will find sample files and code solutions in the Source Code/Download section of the
Apress web site, at www.apress.com.
Who This Book Is For
This book is intended for developers who would like to learn to use Visual Basic for Applications
(VBA) to extend the power of Microsoft Excel 2007. You should have some knowledge of
or experience using the VBA or classic Visual Basic programming languages and their related
development environment.
Pages:
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27