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
Secure Programming Cookbook for C and C++: Recipes for Cryptography, Authentication, Input Validation & More
Splitting a String
Add Margins to a Text File
Justify a Text File
Computing the Norm of a Vector
Working with Xerces Strings
Cisco IOS in a Nutshell (In a Nutshell (OReilly))
The Console Port
show line
Common Configuration Items
Specific Topics
Network Address Translation (NAT)
Google Maps Hacks: Tips & Tools for Geographic Searching and Remixing
Hack 34. Publish Your Own Hiking Trail Maps
Hack 38. Map Your Wardriving Expeditions
Hacks 6270: Introduction
Hack 68. Automatically Cut and Name Custom Map Tiles
Hack 69. Cluster Markers at High Zoom Levels
Logistics and Retail Management: Emerging Issues and New Challenges in the Retail Supply Chain
Retail Logistics: Changes and Challenges
Market Orientation and Supply Chain Management in the Fashion Industry
Rethinking Efficient Replenishment in the Grocery Sector
The Development of E-tail Logistics
Transforming Technologies: Retail Exchanges and RFID
HTI+ Home Technology Integrator & CEDIA Installer I All-In-One Exam Guide
Distributed Video Basics
Designing and Installing Distributed Video Systems
Designing a Home Lighting Control System
Programming
Appendix A Home Technology Project Management
Comparing, Designing, and Deploying VPNs
What Is a Virtual Private Network?
Summary
Comparing IPsec Remote Access VPNs with Other Types of Remote Access VPNs
Understanding the Operation of SSL Remote Access VPNs
Using Clientless SSL Remote Access VPNs (WebVPN) on the Cisco VPN 3000 Concentrator
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