Power Programming with VBA/Excel
by Chapra, Steven C.Format: Paperback
Pub. Date: 2003-01-01
Publisher(s): Prentice Hall
Other versions by this Author
-
This Item Qualifies for Free Shipping!*
*Excludes marketplace orders.
List Price: $43.05
Buy New
Arriving Soon. Will ship when available.
$41.00
Rent Textbook
Select for Price
Used Textbook
We're Sorry
Sold Out
eTextbook
We're Sorry
Not Available
How Marketplace Works:
- This item is offered by an independent seller and not shipped from our warehouse
- Item details like edition and cover design may differ from our description; see seller's comments before ordering.
- Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
- Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
- Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.
Summary
Part ofEsource --Prentice Hall's Engineering Source, this book provides a flexible introduction to the use of VBA/Excel in engineering. Featuring over 25 modules and growing, the ESource series provides a comprehensive resource of essential engineering topics. Covers topics such as an introduction to programming, recording macros, customized worksheet functions, modular and object-oriented programming, strings and dialog boxes, and data structures. For any Engineer or Computer Scientist interested in a brief introduction to VBA/Excel.
Table of Contents
1. If You've Never Programmed Before.
2. Overview of VBA for Excel.
3. Recording Macros.
4. Customized Worksheet Functions.
5. Modular Programming.
6. Object-Oriented Programming.
7. Debugging and Testing.
8. Data Typing and Variable Scope.
9. Computations.
10. Strings and Dialog Boxes.
11. Structured Programming: Decisions.
12. Structured Programming: Lops.
13. Data Structures: Arrays and Records.
14. Creating and Accessing Files.
15. Custom Dialogue Boxes.
The “Idea” of a Program. The Concept of Assignment. Decisions and Loops. A Simple Example.
2. Overview of VBA for Excel.
The Excel/VBA Environment. An Excel Interface and a VBA Macro Program. Other Ways to Obtain and Display Information.
3. Recording Macros.
Macro Recording. Absolute and Relative References. Using Macro Recording to Learn about VBA. What Keyboard Macros Can't Do.
4. Customized Worksheet Functions.
The “Idea” of a Function. Worksheet Function Macros.
5. Modular Programming.
Sub Procedures. Function Procedures. More about Procedure Arguments. Passing by Value or by Reference. Static Variables.
6. Object-Oriented Programming.
Objects, Properties, Methods, and Collections. Using Oop for Input/Output. Learning More about Oop.
7. Debugging and Testing.
Debugging. The VBA Help Facility. Built-in Debugging Capabilities. Testing.
8. Data Typing and Variable Scope.
Data Types. Type Declaration. Variable Scope and Lifetime.
9. Computations.
Computations. Built-in Numeric Functions.
10. Strings and Dialog Boxes.
String Functions and Manipulations. Message Boxes. Input Boxes.
11. Structured Programming: Decisions.
Structured Programming. Flowcharts. The If/Then/Else Decision Structure. The If/Then/Elseif Structure. Selected Case Structure. Nesting. Compound Logical Expressions.
12. Structured Programming: Lops.
Decision Loops (Do/if Exit). Count-Controlled Loops. Nesting of Loops and Decisions. Recursion.
13. Data Structures: Arrays and Records.
Arrays. Records.
14. Creating and Accessing Files.
Sequential Files. Other File Operations.
15. Custom Dialogue Boxes.
A Simple Custom Dialogue Box. Custom Dialogue Boxes and Modules.
Excerpts
Esource--The Prentice Hall Engineering Source-- www.prenhall.com/esource Esource--The Prentice Hall Engineering Source gives professors the power to harness the full potential of their text and their first-year engineering course. More than just a collection of books, ESource is a unique publishing system revolving around the ESource website-- www.prenhall.com/esource . ESource enables you to put your stamp on your book just as you do your course. It lets you: Control.You choose exactly what chapter or sections are in your book and in what order they appear. Of course, you can choose the entire book if you'd like and stay with the authors' original order. Optimize.Get the most from your book and your course. ESource lets you produce the optimal text for your students needs. Customize.You can add your own material anywhere in your text's presentation, and your final product will arrive at your bookstore as a professionally formatted text. Of course, all titles in this series are available as stand-alone texts, or as bundles of two or more books sold at a discount. Contact your PH sales rep for discount information.
An electronic version of this book is available through VitalSource.
This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.
By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.
Digital License
You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.
More details can be found here.
A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.
Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.
Please view the compatibility matrix prior to purchase.