Create Powerful Business Applications with Excel 2003Excel 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 VBADebugging tools and tactics that workMastering the Excel Object ModelDeveloping class modulesCustomizing Excel UserFormsIntegrating Excel with other applicationsIncorporating text files in your solutionCoding solutions that leverage a databaseUsing XML in ExcelDesigning user-friendly toolbars and menusBuilding Excel 2003 Smart DocumentsDeploying your solution Visual Basic for Applications (VBA) is a powerful language embedded in Microsoft Office for creating custom applications with Word, Excel and the other members of the Office suite. With VBA, XML and assorted other technologies, Excel 2003 becomes the ideal solution for a wide variety of custom programming for nearly all levels of business need. not as a desktop application, geared toward business solutions. It incorporates the information and techniques that the author found to be the most useful in his consulting work. basics; VBA debugging tools and techniques; mastering the Excel Object Model; integrating Excel with other applications; Ezxcel development best practices; working with external data; adding user personalization to an application; designing and developing user interfaces; and application distribution strategies and techniqes.