FREE Delivery in the UK.
Only 5 left in stock (more on the way).
Dispatched from and sold by Amazon.
Gift-wrap available.
Quantity:1
VBA for Modelers: Develop... has been added to your Basket
+ £2.80 UK delivery
Used: Good | Details
Sold by Nearfine
Condition: Used: Good
Comment: A good reading copy. May contain markings or be a withdrawn library copy. Expect delivery in 2-3 weeks.
Trade in your item
Get a £36.50
Gift Card.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

VBA for Modelers: Developing Decision Support Systems with Microsoft Office Excel [With Access Code] Paperback – 26 Aug 2011


See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
Paperback, 26 Aug 2011
£107.34
£107.03 £76.96

There is a newer edition of this item:

--This text refers to an alternate Paperback edition.
£107.34 FREE Delivery in the UK. Only 5 left in stock (more on the way). Dispatched from and sold by Amazon. Gift-wrap available.


Trade In this Item for up to £36.50
Trade in VBA for Modelers: Developing Decision Support Systems with Microsoft Office Excel [With Access Code] for an Amazon Gift Card of up to £36.50, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Product details

  • Paperback: 700 pages
  • Publisher: South Western Educational Publishing; 4 Pap/Psc edition (26 Aug. 2011)
  • Language: English
  • ISBN-10: 1133190871
  • ISBN-13: 978-1133190875
  • Product Dimensions: 2.5 x 18.4 x 24.1 cm
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: 995,185 in Books (See Top 100 in Books)

Product Description

Review

Part I: VBA FUNDAMENTALS. 1. Introduction to VBA Development in Excel. Introduction. VBA in Excel 2007 and 2010. Example Applications. Decision Support Systems. Required Background. Visual Basic Versus VBA. Some Basic Terminology. Summary. 2. The Excel Object Model. Introduction. Objects, Properties, Methods, and Events. Collections as Objects. The Hierarchy of Objects. Object Models in General. Summary. 3. The Visual Basic Editor. Introduction. Important Features of the VBE. The Object Browser. The Immediate and Watch Windows. A First Program. Intellisense. Color Coding and Case. Finding Subs in the VBE. Summary. 4. Recording Macros. Introduction. How to Record a Macro. Changes from Excel 2007 to Excel 2010. Recorded Macro Examples. Summary. 5. Getting Started with VBA. Introduction. Subroutines. Declaring Variables and Constants. Built-In Constants. Input Boxes and Message Boxes. Message Boxes with Yes and No Buttons. Using Excel Functions in VBA. Comments. Indenting. Strings. Specifying Objects, Properties, and Methods. With Construction. Other Useful VBA Tips. Good Programming Practices. Debugging. Summary. 6. Working with Ranges. Introduction. Exercise. Important Properties and Methods of Ranges. Referencing Ranges with VBA. Examples of Ranges with VBA. Range Names and Their Scope. Summary. 7. Control Logic and Loops. Introduction. Exercise. If Constructions. Case Constructions. For Loops. For Each Loops. Do Loops. Summary. 8. Working with Other Excel Objects. Introduction. Exercise. Collections and Members of Collections. Examples of Workbooks in VBA. Examples of Worksheets in VBA. Examples of Charts in VBA. Summary. 9. Arrays. Introduction. Exercise. The Need for Arrays. Rules for Working with Arrays. Examples of Arrays in VBA. Array Functions. Summary. 10. More on Variables and Subroutines. Introduction. Exercise. Scope of Variables and Subroutines. Modularizing Programs. Passing Arguments. Function Subroutines. The Workbook Open Event Handler. Summary. 11. User Forms Introduction. Exercise. Designing User Forms. Setting Properties of Controls. Creating a User Form Template. Writing Event Handlers. Displaying a User Form. Looping Through the Controls on a User Form. Working with List Boxes. Modal and Modeless. Working with Excel Controls. Summary. 12. Error Handling. Introduction. Error Handling with On Error Statement. Handling Inappropriate User Inputs. Summary. 13. Working with Files and Folders. Introduction. Exercise. Dialog Boxes for File Operations. The File System Object. A File Renaming Example. Working with Text Files. Summary. 14. Importing Data into Excel from a Database. Introduction. Exercise. A Brief Introduction to Relational Databases. A Brief Introduction to SQL. ActiveX Data Objects (ADO). Discussion of the Sales Orders Exercise. Summary. 15. Working with Pivot Tables and Tables. Introduction. Working with Pivot Tables Manually. Working with Pivot Tables Using VBA. An Example. Working with Excel Tables Manually. Working with Excel Tables with VBA. Summary. 16. Working with Ribbons, Menus, and Toolbars. Introduction. Customizing Ribbons in Excel 2010. Using RibbonX and XML to Customize Ribbons. Using RibbonX to Customize the QAT. CommandBar and Related Office Objects. A Grading Program Example. Summary. 17. Automating Solver and Other Applications. Introduction. Exercise. Automating Solver with VBA. Possible Solver Problems. Programming with Risk Solver Platform. Automating Palisade Add-Ins with VBA. Automating Other Office Applications with VBA. Summary. 18. User-Defined Types, Enumerations, Collections, and Classes. User-Defined Types. Enumerations. Collections. Classes. Summary. Part II: VBA MANAGEMENT SCIENCE APPLICATIONS. 19. Basic Ideas for Application Development with VBA. Introduction. Guidelines for Application Development. A Car Loan Application. Summary. 20. A Blending Application. Introduction. Functionality of the Application. Running the Application. Setting Up the Excel Sheets. Getting Started with the VBA. The User Forms. The Module. Summary. 21. A Product Mix Application. Introduction. Functionality of the Application. Running the Application. Setting Up the Excel Sheets. Getting Started with the VBA. The User Form. The Module. Summary. 22. A Worker Scheduling Application. Introduction. Functionality of the Application. Running the Application. Setting Up the Excel Sheets. Getting Started with the VBA. The User Form. The Module. Summary. 23. A Production Planning Application. Introduction. Functionality of the Application. Running the Application. Setting Up the Excel Sheets. Getting Started with the VBA. The User Forms. The Module. Summary. 24. A Transportation Application. Introduction. Functionality of the Application. Running the Application. Setting Up the Access Database. Setting Up the Excel Sheets. Getting Started with the VBA. The User Form and Its Event Handlers. The VBA Code in the Module. Summary. 25. A Stock Trading Simulation Application. Introduction. Functionality of the Application. Running the Application. Setting Up the Excel Sheets. Getting Started with the VBA. The Module. Summary. 26. A Capital Budgeting Application. Introduction. Functionality of the Application. Running the Application. Setting Up the Excel Sheets. Getting Started with the VBA. The User Form. The Module. Summary. 27. A Regression Application. Introduction. Functionality of the Application. Running the Application. Setting Up the Excel Sheets. Getting Started with the VBA. The User Form. The Module. Summary. 28. An Exponential Utility Application. Introduction. Functionality of the Application. Running the Application. Setting Up the Excel Sheets. Getting Started with the VBA. The User Form. The Module. Summary. 29. A Queuing Simulation Application. Introduction. Functionality of the Application. Running the Application. Setting Up the Excel Sheets. Getting Started with the VBA. The Structure of a Queuing Simulation. The Module. Summary. 30. An Option Pricing Application. Introduction. Functionality of the Application. Running the Application. Setting Up the Excel Sheets. Getting Started with the VBA. The User Form. The Module. Summary. 31. An Application for Finding Betas of Stocks. Introduction. Functionality of the Application. Running the Application. Setting Up the Excel Sheets. Getting Started with the VBA. The User Forms. The Module. Summary. 32. A Portfolio Optimization Application. Introduction. Functionality of the Application. Running the Application. Web Queries in Excel. Setting Up the Excel Sheets. Getting Started with the VBA. The User Forms. The Module. Summary. 33. A Data Envelopment Analysis Application. Introduction. Functionality of the Application. Running the Application. Setting Up the Excel Sheets and the Text File. Getting Started with the VBA. Getting Data from a Text File. The Module. Summary. 34. An AHP Application for Choosing a Job. Introduction. Functionality of the Application. Running the Application. Setting Up the Excel Sheets. Getting Started with the VBA. The User Forms. The Module. Summary. --This text refers to an alternate Paperback edition.

About the Author

S. Christian Albright received his B.S. degree in mathematics from Stanford in 1968 and his Ph.D. in operations research from Stanford in 1972. Since then, he has been teaching in the Operations and Decision Technologies Department in the Kelley School of Business at Indiana University. He has taught courses in management science, computer simulation, and statistics to all levels of business students: undergraduates, MBAs, and doctoral students. Albright has published over twenty articles in leading operations research journals in the area of applied probability, and he has authored other successful South-Western titles, including: DATA ANALYSIS AND DECISION MAKING, DATA ANALYSIS FOR MANAGERS, PRACTICAL MANAGEMENT SCIENCE, and SPREADSHEET MODELING AND APPLICATIONS. His current interest is in spreadsheet modeling, including development of VBA applications in Excel(R). For more information about his books, please visit www.kelley.iu.edu/albrightbooks. --This text refers to an alternate Paperback edition.

Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

5.0 out of 5 stars
5 star
1
4 star
0
3 star
0
2 star
0
1 star
0
See the customer review
Share your thoughts with other customers

Most Helpful Customer Reviews

By Rashid on 26 July 2014
Format: Paperback Verified Purchase
Best book on vba & modelling.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: 8 reviews
10 of 10 people found the following review helpful
Avoid CENGAGE Learning Books if you're not a student! 5 May 2013
By Andrew Wheelwright - Published on Amazon.com
Format: Paperback Verified Purchase
This text uses an online solution provided by CENGAGE Learning ([...]) for accessing the necessary code samples. Unless you are a student or are willing to lie about it (which you should not do), you will not be able to access the online materials. The website is poorly designed with significant reliability and design issues (frequent timeouts, the inability for non-academic users to create accounts, the inability for non-account holders to submit support requests to customer service, etc).

If you are a student then read on. This book is for non-programming business professionals and is intended as a rough and limited introduction to Visual Basic for Applications as it applies to Microsoft Excel in context of business modeling. Most of the book discusses business models for which the author assumes prior knowledge of business management and for which the author suggests his book "Practical Management Science". If you are a professional developer, this book is not for you and will provide limited value. If on the other hand, your a business manager with minimal programming experience and want to enhance your skills and decision making tools, this book will be very helpful to you.
12 of 13 people found the following review helpful
Good Content but no Excel Sheets for People outside USA 9 Nov. 2012
By Amazon Customer - Published on Amazon.com
Format: Paperback
I reside in India and I purchased the book but there was no mention of the site to download the excel sheets from. I wrote to the publisher but still no access. It is just the tactics to publish the old editions of the books prevalent in USA. There is nothing wrong with this approach but for a book like this where the entire value lies in the accompanying the publisher refuses to provide it then its outright outrageous and of no use. Buying the book without accompanying excel sheets is just like throwing money down the drain.
5 of 5 people found the following review helpful
VBA for Modelers: good book, bad product 24 Jun. 2013
By Amazon Customer - Published on Amazon.com
Format: Kindle Edition Verified Purchase
VBA for Modelers: Developing Decision Support Systems with Microsoft Office Excel - Kindle version
This is a very good book if we look to the content: good tutorials on VBA, very useful examples, clear explanations.
But, unfortunately, it is a bad product. There is no access to the codes, as promissed in the preface:
"The companion Web site for this book can be accessed at www.cengagebrain.com. There you will have access to all of the Excel (.xlsx and .xlsm) and other files mentioned in the chapters, including those in the exercises."
At such site there is a box for product registering, but the access code (should be similar to PP8XLP3XD528HC, as informed there) was never provided.
Also, if we spend a time trying to obtain any support, we only find FAQ technical support and sales support. By trying to register a question, after filling a series of boxes, we must inform the educational institution. As a common customer isn't linked to any institution, in practical terms, it is impossible to register the customer or the book in this site.
So, if you like to read extreme small letters (all the codes are small images which size is always the same small, independent of text size you set), if you like to type large codes and if you like to support yourself, then this book is for you.
7 of 8 people found the following review helpful
Well-written, fun and useful 25 Nov. 2011
By Chaz McCaz - Published on Amazon.com
Format: Paperback
This is easily the best book I have ever seen on learning and using VBA for Excel. Unlike the "Dummies" series, this book is geared more towards those with operational or analytic inclinations (not just simply formatting or automating a spreadsheet). However, the first half of the book is also suitable for any VBA beginner that is interested in starting from the ground up. The second half has some very interesting and fun examples from OR/mgmt science/decision science that could actually be used on the job. Yet they are fun enough to work through even if you're not in that field, and don't require any "high-level" math to understand.

I'd say the main strengths of the book are as follows:

1)Very well written - I got the sense that the author went through a ton of trial and error (and googling) to figure out how to do the things he teaches in this book. Hence, it is written from the perspective of a real user rather than a typical computer book author who recycles old and sometimes suspect information from other sources without fully understanding it.
2)Comprehensive examples - the author never leaves you hanging without examples to illustrate what he teaches. Virtually every point comes with code examples that can be used to complete the exercises at the end of the chapters.
3)Comprehensive premium online content - the book comes with free access to premium online content that includes code examples in pre-constructed spreadsheets (so you can actually see how it works) and code-free spreadsheets for the exercises (the author gives you the data and your job is to write code for it). You also get to learn how to integrate code with Excel Solver and @Risk (you get limited access to @Risk with the book).
4)Interesting problems - the author gives some classic mgmt science problems (e.g. Travelling Salesman) and shows you how to use VBA to solve the problem. It is very fun to work the problems and actually becomes kind of addictive. Later in the book the problems become more advanced and range from scheduling to stock trading.

The Dummies books may be cheaper but this book is far better. Also, the problems and examples in this book are much more interesting that what you find elsewhere, so it actually motivates you to learn the material.
1 of 1 people found the following review helpful
Did NOT include Access Card 16 Jan. 2013
By BaDnNC - Published on Amazon.com
Format: Paperback Verified Purchase
I would attempt to return this item but my class has started and I need the book. It looked brand new and was packaged like new, but when I went to attempt to open the envelope for the access card there was nothing in it and the top of the envelope was NOT sealed. This is very frustrating because I'm stuck now without the files needed for the book.
Were these reviews helpful? Let us know


Feedback