---

Microsoft Office Excel 2003 Programming Inside Out (Inside Out (Microsoft))

ISBN: 0735619859
EAN: 2147483647

Year: 2006
Pages: 161

Authors: Curtis Frye D., Wayne S. Freeze, Felicia K. Buckingham

BUY ON AMAZON

• Table of Contents
• BackCover
• Microsoft Office Excel 2003 Programming Inside Out
• Part 1: Preliminaries
• Chapter 1: What s New in Excel 2003
• Creating Smart Documents
• Creating Document Workspaces
• Implementing Information Rights Management
• Comparing Workbooks Side By Side
• Getting Information with the Research Task Pane
• Using Extended XML Capabilities
• Chapter 2: Exploring Excel
• Worksheets
• Cells and Ranges
• The Excel Interface
• Formulas
• Part 2: Visual Basic for Applications
• Chapter 3: Exploring Visual Basic for Applications
• Working with Macros
• Chapter 4: VBA Programming Starter Kit
• Managing Code Windows
• Developing Projects with the Project Explorer
• Declaring Variables, Constants, and Data Types
• Assigning Values to Variables
• Working with Arrays
• Creating Dynamic Arrays
• Writing to the Screen and Accepting Input
• Defining Object Variables
• Creating Custom Data Types
• Controlling Program Flow
• Error Handling
• Chapter 5: Creating Sub and Function Procedures
• Defining Function Procedures
• Organizing for Success
• Part 3: The Excel Object Model
• Chapter 6: The Application Object
• Introducing the Application Object
• Chapter 7: Workbooks and Worksheets
• The Sheets and Worksheets Collections
• Chapter 8: Ranges and Cells
• Referring to Ranges
• Manipulating Groups of Cells
• Using Named Ranges
• Getting Data Entry Right the First Time
• Part 4: Advanced VBA
• Chapter 9: Manipulating Data with VBA
• Manipulating Text
• Manipulating Numbers
• Manipulating Dates and Times
• Chapter 10: Formatting Excel Objects
• Formatting Worksheet Elements
• Formatting Fonts
• Formatting Cells
• Formatting Borders
• Chapter 11: Creating Add-Ins and COM Add-Ins
• Using the Add-Ins dialog box
• Creating Excel Add-Ins
• Using the AddIns Collection
• Creating Automation and COM Add-Ins
• Building an Automation Add-In with Visual Basic 6
• Building a COM Add-In with Visual Basic .NET
• Chapter 12: Understanding and Using Events
• Enabling and Disabling Events
• Workbook Events
• Worksheet Events
• Application Events
• Chapter 13: Manipulating Files
• Writing to an External File
• Reading from an External File
• Searching a File for a Value
• Chapter 14: Developing Class Modules
• Introducing Class Modules
• Properties, Methods, and Events
• Building a Class
• Practical Class Design
• Part 5: Manipulating Excel Objects
• Chapter 15: Charts
• Introducing Charts
• Manipulating Charts
• Final Thoughts on Programming Charts
• Chapter 16: PivotTables and PivotCharts
• PivotTable Objects
• Programming PivotTables
• Manipulating PivotTables Programmatically
• Chapter 17: Command Bars
• Command Bar Controls
• Chapter 18: Customizing Dialog Boxes
• Displaying Existing Dialog Boxes
• Modifying Existing Dialog Boxes
• Planning with Dialog Boxes
• Chapter 19: Creating User Forms
• UserForm Controls
• Chapter 20: Creating Advanced User Forms
• Building a Multi-Step Wizard
• Part 6: Excel and the Outside World-Collaborating Made Easy
• Chapter 21: Excel and Other Office Applications
• Starting Another Application
• Activating Another Application
• Binding
• Interacting with Other Office Applications
• Working with Multiple Applications to Get the Job Done
• Chapter 22: Excel and the Structured Query Language
• Manipulating Databases with SQL
• The Select Statement
• The Insert Statement
• The Update Statement
• The Delete Statement
• Chapter 23: Introducing ADO
• The ADO Object Model
• The Connection Object
• The Command Object
• The Recordset Object
• Chapter 24: Excel Query Program
• Connecting to a Database
• Editing a Query
• Executing a Database Query
• Using the Excel Query Program
• Chapter 25: Excel and the Web
• HTML
• Using the Internet as a Data Source
• Using the Internet to Publish Results
• Using Internet Solutions with Excel
• Chapter 26: Excel and the Extensible Markup Language (XML)
• Introducing Data Lists
• Creating XML Schemas
• Creating XML Data Files
• Adding XML to a Workbook Manually
• Adding XML to a Worksheet Programmatically
• Index
• 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
• List of Tables
• List of Inside Out
• List of Sidebars
• List of Troubleshooting