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
Database Modeling with MicrosoftВ® Visio for Enterprise Architects (The Morgan Kaufmann Series in Data Management Systems)
Introduction
Reverse Engineering and Importing to ORM
Reverse Engineering Physical Schemas to Logical Models
Change Propagation and Round Trip Engineering
Other Features and Best Practices
Cisco IOS in a Nutshell (In a Nutshell (OReilly))
Asynchronous Ports (TTYs)
Specific Topics
Fast Switching and Process Switching
Traffic Policing
IOS on Switches
Cisco IOS Cookbook (Cookbooks (OReilly))
Scheduling of Router Commands
Adjusting Timers
Redistributing External Routes into OSPF
Tunneling Foreign Protocols in IP
Using NTP to Send Periodic Broadcast Time Updates
GDI+ Programming with C#
Clipping Regions Example
Using a Picture Box to View Images
A Brief History of Printing with Microsoft Windows
Appendix A. Exception Handling in .NET
Section A.1. Why Exception Handling?
Python Programming for the Absolute Beginner, 3rd Edition
Telling the Monkeys What to Do
Deleting Directory Trees
Menus
Advanced GUI Coding Techniques
Registering Callback Handler Objects
Microsoft Visual Basic .NET Programmers Cookbook (Pro-Developer)
Objects, Interfaces, and Patterns
Reflection
Windows Controls
ADO.NET
Security and Cryptography
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