Flylib.com
Linux Application Development For The Enterprise (Charles River Media Programming)
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
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
CompTIA Project+ Study Guide: Exam PK0-003
IT Project+ Study Guide
Assessment Test
Schedule Planning
Project Execution
Appendix A Systems Development Life Cycle
Developing Tablet PC Applications (Charles River Media Programming)
Working with VB .NET
Math and Random Number Functions in VB .NET
Introduction to Ink-Enabled Applications
Creating an MP3 Player
Form Effects
Cisco Voice Gateways and Gatekeepers
Dial Plan Considerations
Dial Plan Considerations
Allowing H.323 to SIP Connections
Case Study: Configuring SIP Between a Gateway and CallManager 5.x
CallManager and Gatekeepers
Competency-Based Human Resource Management
Why a Focus on Jobs Is Not Enough
An Overview of Competency-Based HR Management Practices
Competency-Based Employee Development
The Transformation to Competency-Based HR Management
Appendix B Further Suggestions on Employee Development
Information Dashboard Design: The Effective Visual Communication of Data
Thirteen Common Mistakes in Dashboard Design
Misusing or Overusing Color
Tapping into the Power of Visual Perception
Sample CIO Dashboard
Sample Marketing Analysis Dashboard
User Interfaces in C#: Windows Forms and Custom Controls
Creating Usable Interfaces
Control Class Basics
Modern Controls
MDI Interfaces and Workspaces
GDI+ Basics
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies