Appendix A
Introduction to Visual Basic for Applications
Chapter 7 showed you how to call your decision service using Visual Basic for Applications (VBA). Since not every reader has used VBA before, we include this appendix to get you started.
Introduction to macros and VBA
When launched in 1993 (yes, 1993), VBA was revolutionary. Earlier versions of Excel and other spreadsheets had Macros, which offered little more than a replay of user keystrokes. VBA provided the ability to record user actions as a programming language (similar to the popular Basic language of the day) and then allowed users to modify that in the code editor. It gave an easy path for Excel power users (like you!) to learn to solve problems while leaving the door open to upgrade ...
Get AI and Business Rule Engines for Excel Power Users 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.
