---

Linux Application Development For The Enterprise (Charles River Media Programming)

ISBN: 1584502533
EAN: 2147483647

Year: 2002
Pages: 134

Authors: Satya Sai Kolachina

BUY ON AMAZON

• BackCover
• BackCover
• Definitive Guide to Excel VBA, Second Edition
• Preface
• Excel and .NET
• Why This Book?
• Enjoy
• The Idea Behind This Book
• The Example Files
• Excel XP or Excel 2002? Office XP or Office 2002?
• Part One: An Intuitive Approach
• Chapter 1: Writing Your First Macro
• 1.2 What Is Visual Basic for Applications?
• 1.3 Linking a Custom Style with a Tool
• 1.4 A Macro for Simplifying Input
• 1.5 A Simple Literature Database
• 1.6 A Form for Computing Interest in a Savings Account
• 1.7 User-Defined Functions
• 1.8 Analysis of Complex Tables
• 1.9 A Vocabulary Tutor
• 1.10 Example Programs for You to Try
• Chapter 2: What s New in Excel 2000
• 2.2 New in Excel 2000
• 2.4 New in Excel 7
• 2.5 Problems and Incompatibilities
• Part Two: Fundamentals
• Chapter 3: The Development Environment
• 3.2 The Components of the Development Environment
• 3.3 Code Input in Modules
• 3.4 Executing Macros
• 3.5 Recording Macros
• 3.6 Keyboard Shortcuts
• Chapter 4: VBA Concepts
• 4.2 Procedural Programming
• 4.3 Objects
• 4.4 Events
• 4.5 Programming Your Own Classes
• 4.6 Operators in VBA
• 4.7 Virus Protection
• Chapter 5: Techniques of Programming
• 5.2 Workbooks, Windows, and Worksheets
• 5.3 Data Transfer via the Clipboard
• 5.4 Working with Numbers and Character Strings
• 5.5 Working with Dates and Times
• 5.6 Working with Files
• 5.7 User-Defined Worksheet Functions
• 5.8 Protection Mechanisms
• 5.9 Configuration Files, Custom Configuration
• 5.10 Excel Meets the Euro
• 5.11 Tips and Tricks
• Chapter 6: Debugging, Protection When Errors Arise
• 6.2 Error-Tolerant Behavior of Programs
• 6.3 Response to Program Interrupts
• 6.4 Syntax Summary
• Chapter 7: Forms (Microsoft Forms Library)
• 7.2 User-Defined Forms
• 7.3 The Form Editor
• 7.4 The MS Forms Controls
• 7.5 Placing Controls Directly into Worksheets
• 7.6 Programming Techniques
• Chapter 8: Menus and Toolbars
• 8.2 Formatting the Interface for Freestanding Excel Applications
• Part Three: Application
• Chapter 9: Templates, Smart Forms
• 9.1 Fundamentals
• 9.2 Example: The Speedy Invoice Form
• 9.3 Example: Balance Sheet for a Car-Sharing Club
• 9.4 The Limits of Smart Forms
• Chapter 10: Charts and Drawing Objects (Shapes)
• 10.2 Programming Charts
• 10.3 Example: Automatic Data Reporting
• 10.4 Syntax Summary for Charts
• 10.5 Drawing Objects (Shapes)
• 10.6 Diagrams
• Chapter 11: Data Management in Excel
• 11.1 Fundamentals
• 11.2 Data Management Within Excel
• 11.3 Data Processing in VBA Code
• 11.4 Database Worksheet Functions
• 11.5 Consolidating Tables
• 11.6 Example: Balance Sheet for a Car-Sharing Club
• Chapter 12: Access to External Data
• 12.2 Importing External Data
• 12.3 Database Access with the ADO Library
• 12.4 Example: Evaluating a Questionnaire
• Chapter 13: Data Analysis in Excel
• 13.2 Pivot Tables
• 13.3 Programming Techniques
• Chapter 14: VBA Programming for Pros
• 14.2 Excel and the Internet
• 14.3 Smart Tags
• 14.4 Using Web Services
• 14.5 Using Dynamic Link Libraries (DLLs)
• 14.6 ActiveX Automation
• Part Four: Reference
• Chapter 15: Object Reference
• 15.2 Alphabetical Reference
• Appendix: Excel 2003 Beta 2
• What s New in Excel 2003
• Office 2003 and .NET
• List Processing
• Excel 2003 and XML (Extensible Markup Language)
• XML Programming
• Object Reference
• References
• Index
• Index_Numbers
• Index_A
• Index_B
• Index_C
• Index_D
• Index_E
• Index_F
• Index_G
• Index_H
• Index_I
• Index_J
• Index_K
• Index_L
• Index_M
• Index_N
• Index_O
• Index_P
• Index_Q
• Index_R
• Index_S
• Index_T
• Index_U
• Index_V
• Index_W
• Index_X
• Index_Y
• Index_Z
• List of Figures