Your business logic will reside in objects, and the UI will send data to
CHAPTER 1 n THE MACRO RECORDER AND CODE MODULES 40
and from them. Your data layer will be compartmentalized and reusable between applications.
Any workflow can be stored in classes and used in any application that needs it. You??™ll
develop code libraries that will provide easy access to your object-based functionality. How
do you transport this functionality from application to application? Simply import the class!
If you create a lot of Excel applications, you may even find yourself building a reusable
framework from which you can create new applications that will already contain your base
functionality.
Summary
In Chapter 1, you looked at the Excel 2007 Macro Recorder and learned how to use it to let
Excel generate code for you. This is useful when learning the Excel 2007 object model, and it
can also be used to generate base code that you can then edit to suit your purpose.
You worked with the Excel Visual Basic Editor (VBE), where you created macros to
enter and format data. The VBE is similar to the VB 6 code editor, and includes many of the
same tools for debugging your code, such the Immediate window, the Locals window, and
the Watch window. You were introduced to Excel??™s Object Browser, which contains tools
that let you examine the libraries in your project and investigate an object??™s methods and
properties.
You also looked at standard code modules. Standard code modules contain subroutines,
functions, and type statements.
Pages:
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68