![]() Understanding the Crystal Ball Macro Framework Given that Oracle Crystal Ball runs on Excel, it is worth exploring how VBA can create behaviors that are NOT natural to Excel. Nearly 20 years hence, we have Excel VBA (Visual Basic for Applications) to enable to build complete and robust macros. Before Excel VBA, Lotus 1-2-3 had a very cool tool known as HAL (Human Access Language) (See NY Times, 1986) that enabled you to sequence a large number of tasks using human language. ![]() I have been using spreadsheets to model stuff (even primitively) for the better part of 20 years… From my very beginnings with Visicalc using an old Apple IIe my Dad gave me to Lotus 123 on a PC my Dad gave me to Excel on a computer I bought myself. ![]() ![]() What’s so great about Excel VBA when you Model? Given that Oracle Crystal Ball runs on Excel, it is worth exploring how VBA can create behaviors that are NOT natural to Excel! This article provides a highlevel overview of how and why to integrate VBA in Crystal Ball spreadsheet models. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |