Power Programming with VBA/Excel
Published on 10. January 2003
Book
Paperback/Softback
191 pages
978-0-13-047377-6 (ISBN)
Description
For Freshman or Introductory courses in Engineering and Computer Science.
ESource-Prentice Hall's Engineering Source-provides a comprehensive, customizable introductory engineering and computing library. Featuring over 25 modules and growing, ESource allows professors to fully customize their textbooks through the ESource website. Professors are not only able to pick and choose complete modules, but also custom-build a freshman engineering text that matches their content needs and course organization exactly! Using the ESource online BookBuild system at www.prenhall.com/esource, they can view and select book chapters, change the sequence, instantly calculate the book's net (bookstore) price, request a free examination copy, and generate an ISBN for placing a bookstore order. They can also add your own course notes, syllabi, reference charts, or other favorite materials, including material from third-party publishers. ESource Access Card: 0-13-090400-7. Include this ISBN when setting up an ESource Bundle.
ESource-Prentice Hall's Engineering Source-provides a comprehensive, customizable introductory engineering and computing library. Featuring over 25 modules and growing, ESource allows professors to fully customize their textbooks through the ESource website. Professors are not only able to pick and choose complete modules, but also custom-build a freshman engineering text that matches their content needs and course organization exactly! Using the ESource online BookBuild system at www.prenhall.com/esource, they can view and select book chapters, change the sequence, instantly calculate the book's net (bookstore) price, request a free examination copy, and generate an ISBN for placing a bookstore order. They can also add your own course notes, syllabi, reference charts, or other favorite materials, including material from third-party publishers. ESource Access Card: 0-13-090400-7. Include this ISBN when setting up an ESource Bundle.
More details
Language
English
Place of publication
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Height: 254 mm
Width: 203 mm
Thickness: 10 mm
Weight
431 gr
ISBN-13
978-0-13-047377-6 (9780130473776)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
New editions
Steven Chapra | Steven C. Chapra
Introduction to VBA for Excel
Book
09/2009
2nd Edition
Pearson
€106.99
Shipment within 15-20 days
Person
Steven C. Chapra presently holds the Louis Berger Chair for Computing and Engineering in the Civil and Environmental Engineering Department at Tufts University. Dr. Chapra received engineering degrees from Manhattan College and the University of Michigan. Before joining the faculty at Tufts, he taught at Texas A&M University, the University of Colorado, and Imperial College, London. His research interests focus on surface water-quality modeling and advanced computer applications in environmental engineering. He has published over 50 refereed journal articles, 20 software packages and 6 books. He has received a number of awards including the 1987 ASEE Merriam/Wiley Distinguished Author Award, the 1993 Rudolph Hering Medal, and teaching awards from Texas A&M, the University of Colorado, and the Association of Environmental Engineering and Science Professors.
Content
1. If You've Never Programmed Before.
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.
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.