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
CISSP Exam Cram 2
About This Book
Physical Security Risks
Message Privacy
Parameters of Investigation
Major Legal Systems
Network Security Architectures
Network Security Promotes Good Network Design
Good Network Security Is Predictable
IP Telephony
What Is the Edge?
Protocol Capabilities
Visual C# 2005 How to Program (2nd Edition)
Terminology
Argument Promotion and Casting
Font Control
Generic Method Implementation
B.6. Negative Binary Numbers: Twos Complement Notation
Logistics and Retail Management: Emerging Issues and New Challenges in the Retail Supply Chain
Relationships in the Supply Chain
Fashion Logistics and Quick Response
The Development of E-tail Logistics
Transforming Technologies: Retail Exchanges and RFID
Enterprise Resource Planning (ERP) Systems: Issues in Implementation
Cultural Imperative: Global Trends in the 21st Century
Culture and Climate
Cross-Century Worldviews
Cognitive Processes
Americanization versus Asianization
Appendix C National Traits
Digital Character Animation 3 (No. 3)
Designing a Character
Creating Characters
Reptiles
Chapter Ten. Directing and Filmmaking
Developing a Story
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