Mastering Excel 2003 Programming with VBA
- 9h 36m
- Steven M. Hansen
- Sybex
- 2004
Excel 2003 is an ideal application development platform for all levels of business needs. If you're an advanced Excel user looking to gain programming experience, or a skilled developer new to Excel or the Excel Object Model, this no-nonsense book teaches you how to build custom applications that can generate substantial time and cost savings for you, your employer, and your customers.
Written by a professional with nearly a decade of experience producing Excel/VBA solutions, Mastering Excel 2003 Programming with VBA conveys the precise knowledge and techniques you need to be highly productive. You’ll master the most critical Excel objects and development practices necessary to create a complete solution, including working with XML data, Smart Document technology, and database integration with ADO. And you can readily apply the practical advice and reusable code examples to your own projects.
In his friendly style, author Steven Hansen makes the information easy to grasp and entertaining to read, and he does not shy away from challenging material. You’ll learn all about:
- Ramping up with VBA Debugging tools and tactics that work
- Mastering the Excel Object Model Developing class modules
- Customizing Excel UserForms
- Integrating Excel with other applications
- Incorporating text files in your solution
- Coding solutions that leverage a database
- Using XML in Excel
- Designing user-friendly toolbars and menus
- Building Excel 2003 Smart Documents
- Deploying your solution
About the Author
Steven M. Hansen has been developing sophisticated analytical software applications with Excel and VBA for nearly a decade. In 1998 he founded Dakota Technology Group, Inc., a consulting firm specializing in software development that enables analysts and other knowledge workers to perform more efficiently. Steve has an MBA from the University of Minnesota's Carlson School of Management and is the co-author of Mastering Excel 2000 Premium Edition, from Sybex.
In this Book
-
Excel as a Development Platform
-
Getting to Know Your Environment
-
Getting Started with VBA
-
Debugging Tactics that Work
-
Exploring the Application Object
-
Working with the Workbook Object
-
Winning with Worksheets
-
The Most Important Object
-
Practical Range Operations
-
Exploring Other Excel Objects
-
Developing Class Modules
-
Adding User Personalization to Your Application
-
Excel Development Best Practices
-
Integrating with Other Applications
-
Incorporating Text Files in Your Solution
-
Dealing with Databases
-
XL(M) = XML
-
Basic User Interfaces
-
Taking Control of Command Bars
-
User Form Construction
-
One Smart Cookie: Smart Documents with Excel 2003
-
Application Deployment Strategies
