Microsoft Office Excel 2003 Programming Inside Out (Inside Out (Microsoft))
Microsoft Office Excel 2003 Programming Inside Out (Inside Out (Microsoft))
ISBN: 0735619859
EAN: 2147483647
EAN: 2147483647
Year: 2006
Pages: 161
Pages: 161
- 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
Microsoft Office Excel 2003 Programming Inside Out (Inside Out (Microsoft))
ISBN: 0735619859
EAN: 2147483647
EAN: 2147483647
Year: 2006
Pages: 161
Pages: 161