But it allows controlling it and manage the actions 8 Paris, JSlide 9 VBA What you can do with it (2) VBA - Introduction (4) Add code to control and react to events that happen in a workbook, a worksheet, or a chart Example: A procedure that handles what happens when the selected cell changes The events that correspond to Sheet2 are listed.
To start the VBA Editor: 6 Paris, JSlide 7 VBA How does it look like? VBA - Introduction (2) The Microsoft Visual Basic Editor allows managing VBA projects Natural language is not (yet?) possible: you need to enter VBA code ? 7 Paris, JSlide 8 VBA What you can do with it (1) VBA - Introduction (3) Design forms: Forms are dialog boxes used to interact with the user The toolbox allows you to add controls to the form No programming is required to design the form. VBA is a special version of Visual Basic aimed at automating simple tasks, and developing basic up to complex applications within Office programs. First version was released with Excel 97.
It is a standard that allows components developed with different languages to communicate Consequence: You can develop your own applications using either VBA, or other programming languages to call XLSTAT VBA or C++ functions 3 Paris, JSlide 4 How does it work? Architecture (2) How XLSTAT works Excel spreadsheet Input data XLSTAT VBA Load data Excel spreadsheet Display results XLSTAT VBA Clean data Call XLSTAT C++ XLSTAT VBA Get results Print results COM interface XLSTAT C++ Engine 4 Paris, JSlide 5 Adding your own code Architecture (3) You can use the XLSTAT VBA layer, or use XLSTAT as a bridge to the XLSTAT C++ layer Your VBA code 5 Paris, JSlide 6 VBA What is it? VBA - Introduction (1) VBA is a TLA (3 letters acronym) for Visual Basic for Applications. XLSTAT User Conference June 7 - 8 2007 Paris, France Programming with XLSTAT and VBA Programming with XLSTAT & VBA Slide 2 Outline XLSTAT Architecture VBA Introduction VBA Syntax VBA Debugging VBA Using external code Outline 2 Paris, JSlide 3 XLSTAT Architecture Architecture (1) Since version 2006 XLSTAT uses the COM interface to let the VBA and C++ layers communicate.
0 kommentar(er)
