tailieunhanh - modeling structured finance cash flows with microsoft excel a step by step guide phần 9

Giao dịch hoán đổi là khó hiểu với nhiều người bởi vì họ liên quan đến khái niệm có thể đảo ngược. Toàn bộ cuốn sách được dành riêng để mô tả những gì giao dịch hoán đổi và làm thế nào họ làm việc. Mục tiêu của phần này để giới thiệu một cách rất ngắn gọn để giao dịc | Automation Using Visual BasicApplications VBA 157 FIGURE The Standard Toolbar looks similar to other Office Toolbars but has unique buttons specifically for creating editing and running code. The Project Explorer and the Properties Window To the left side of the VBE there are two important windows the Project Explorer and the Properties Window. The Project Explorer looks a little like Windows Explorer in the way it organizes information. It is set up as a directory tree where more detailed information within a general concept can be expanded or compressed by clicking on and - symbols. The most general category in VBA is a Project which is essentially the Excel workbook and any associated additions created in the VBE. The first subfolder contains the Excel objects which are the individual sheets in the workbook. Code can be stored under a sheet or for the workbook in general but for this book s examples code will be created and stored in a module. A module is a separate area to enter code. The code is often organized by purpose and functionality into individual sections called subroutines. Basic macros use one subroutine to accomplish a task while more advanced macros often use multiple subroutines. Related subroutines are stored in the same module. For instance a module might be named Print_Routines and contain three subroutines that format and print different sections of the Excel workbook. See Figure for a detailed look at a module. VBA CODE Writing VBA code is like typing out a set of instructions using words and values that are specific to Excel. Trying to run code that Excel does not understand will generate an error and stop the subroutine from running. For a crash course in VBA the most basic elements that a new programmer should know are objects methods and variables. While there are certainly more components to VBA learning about É-Ss Modules Print-Routines Scenarios Solver-Routines FIGURE Modules organize code for subroutines and functions.