Anyone with VBA, Visual Basic, Microsoft Access, or .NET experience will readily understand
the concepts in this book, but anyone with any coding experience should have no
problem with the material.
How This Book Is Structured
This book gives a view into the many features available to today??™s Excel developer, from a
tour of the Visual Basic Editor, where coding is done, to its debugging features. It also provides
modern coding techniques, including object-oriented programming. You??™ll learn
about data access, XML, charting, and PivotTables, UserForms, and more.
Chapter 1 is a basic tour of Excel 2007 coding features, from the development environment
to other tools you??™ll use. It begins with an examination of the Visual Basic Editor and
xvii
shows some of its features. It then looks at the Excel Macro Recorder and the code it generates
for you, talks about the different types of code modules available to you, and discusses the
types of code you can write.
Chapter 2 details methods of bringing data into and out of Excel projects. It covers
importing from Microsoft Access data, text files, and SQL Server data. It also discusses the
many data access options available, including DAO, ADO, and ODBC.
Chapter 3 discusses using the XML features in Excel 2007. Examples include importing
and exporting data to an XML file and appending data from an XML file. It shows how to build
a custom object in a class module to work with XML files. It also shows how to build a custom
user interface component using XML.
Pages:
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28