VBA for modelers : developing decision support systems with Microsoft Office Excel / S. Christian Albright.Call number: 658.4030285 A342V 2012 Material type: BookPublisher: Australia : South-Western/Cengage Learning, c2012Edition: 4th ed., International ed.Description: xx, 700 p. : ill.ISBN: 9781133584230 (pbk.).Subject(s): Decision support systems | Microsoft Excel (Computer file) | Microsoft Visual Basic for applications
Part I. VBA fundamentals. 1, Introduction to VBA development in Excel. 2, The Excel object model. 3, The visual basic editor. 4, Recording macros. 5, Getting started with VBA. 6, Working with ranges. 7, Control logic and loops. 8, Working with other Excel objects. 9, Arrays. 10, More on variables and subroutines. 11, User forms. 12, Error handing. 13, Working with files and folders. 14, Importing data into Excel from a database. 15, Working with pivot tables and tables. 16, Working with ribbons, toolbars, and menus. 17, Automating solver and other applications. 18, User-defined types, enumerations, collections, and classes -- Part II. VBA management science applications. 19, Basic ideas for application development with VBA. 20, A blending application. 21, A product mix application. 22, A worker scheduling application. 23, A production-planning application. 24, A transportation application. 25, A stock-trading simulation application. 26, A capital budgeting application. 27, A regression application. 28, An exponential utility application. 29, A queueing simulation application. 30, An option-pricing application. 31, An application for finding betas of stocks. 32, A portfolio optimization application. 33, A data envelopment analysis application.