Mastering Excel 2003 Programming with VBA (eBook)

Steven M. Hansen (Autor)

eBook Download: PDF

2006 | 1. Auflage
608 Seiten
John Wiley & Sons (Verlag)
978-0-7821-5105-3 (ISBN)

Infos

Create Powerful Business Applications with Excel 2003Excel 2003 is an ideal application development platform for alllevels of business needs. If you're an advanced Excel user lookingto gain programming experience, or a skilled developer new to Excelor the Excel Object Model, this no-nonsense book teaches you how tobuild custom applications that can generate substantial time andcost savings for you, your employer, and your customers.Written by a professional with nearly a decade of experienceproducing Excel/VBA solutions, Mastering Excel 2003 Programmingwith VBA conveys the precise knowledge and techniques you needto be highly productive. You'll master the most critical Excelobjects and development practices necessary to create a completesolution, including working with XML data, Smart Documenttechnology, and database integration with ADO. And you can readilyapply the practical advice and reusable code examples to your ownprojects.In his friendly style, author Steven Hansen makes theinformation easy to grasp and entertaining to read, and he does notshy 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

Autor

Steven Hansen has been developing analytical software applications since 1997, and founded Dakota Technology Group, Inc., in 1998. Most of the software he develops uses Excel. He also offers training geared towards increasing the efficiency of analysts. Prior to 1997, Steve was a financial analyst using VBA with Excel to perform sophisticated analyses and to automate analytical processes. He has a BA degree in history from Rollins College and an MBA degree from the University of Minnesota.

Inhalt

Introduction.Part 1: Introduction to Excel Development.Chapter 1: Excel as a Development Platform.Chapter 2: Getting to Know Your Environment.Chapter 3: Getting Started with VBA.Chapter 4: Debugging Tactics that Work.Part 2: Mastering the Excel Object Model.Chapter 5: Exploring the Application Object.Chapter 6: Working with the Workbook Object.Chapter 7: Winning with Worksheets.Chapter 8: The Most Important Object.Chapter 9: Practical Range Operations.Chapter 10: Exploring Other Excel Objects.Part 3: Advanced Excel Programming Techniques.Chapter 11: Developing Class Modules.Chapter 12: Adding User Personalization to YourApplication.Chapter 13: Excel Development Best Practices.Part 4: Working with External Data.Chapter 14: Integrating with Other Applications.Chapter 15: Incorporating Text Files in Your Solution.Chapter 16: Dealing with Databases.Chapter 17: XL(M) = XML.Part 5: Enhancing the End User Experience.Chapter 18: Basic User Interfaces.Chapter 19: Taking Control of Command Bars.Chapter 20: User Form Construction.Chapter 21: One Smart Cookie: Smart Documents with Excel2003.Chapter 22: Application Deployment Strategies.Index.

Produkt-Details

• Erscheint lt. Verlag: 18.7.2006
• Sprache: englisch
• Themenwelt: Informatik ► Office Programme ► Excel
• Schlagworte: Computer-Ratgeber • End-User Computing • Excel 2003 • Microsoft Excel
• ISBN-10: 0-7821-5105-1 / 0782151051
• ISBN-13: 978-0-7821-5105-3 / 9780782151053