Home Page Icon
Home Page
Table of Contents for
Cover
Close
Cover
by Jim DeMarco
Pro Excel 2007 VBA
Title Page
Dedication
Contents at a Glance
Contents
About the Author
About the Technical Reviewer
Acknowledgments
Introduction
Who This Book Is For
How This Book Is Structured
Prerequisites
Downloading the Code
Contacting the Author
CHAPTER 1: The Macro Recorder and Code Modules
Macro Security Settings
The Visual Basic Development Environment
Recording a Macro
Writing a Macro in the VBE
The Object Browser
Standard Code Modules
Class Modules
UserForms
Object-Oriented Programming: An Overview
Summary
CHAPTER 2: Data In, Data Out
Excel's Data Import Tools
Using DAO in Excel 2007
Using ADO in Excel 2007
Of Excel, Data, and Object Orientation
Summary
CHAPTER 3: Using XML in Excel 2007
Importing XML in Excel 2007
Appending XML Data
Saving XML Data
Building an XML Data Class
Adding a Custom Ribbon to Your Workbook
Summary
CHAPTER 4: UserForms
Creating a Simple Data Entry Form
Creating Wizard-Style Data Entry UserForms
Summary
CHAPTER 5: Charting in Excel 2007
Getting Started
Summarizing with Pie Charts
Summary
CHAPTER 6: PivotTables
Putting Data into a PivotTable Report
Summary
CHAPTER 7: Debugging and Error Handling
Debugging
Error Handling
Summary
CHAPTER 8: Office Integration
Creating a Report in Word
Creating a PowerPoint Presentation
Summary
CHAPTER 9: ActiveX and .NET
Using ActiveX Components in Your Excel 2007 Projects
Excel in the .NET World
Summary
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Next
Next Chapter
Title Page
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset