The latest release of the Microsoft Office family of applications comes with many bells and whistles. Needless to say, Microsoft Office Excel 2003 wins again as the world's number one spreadsheet. In today's business world, millions of users put Excel through myriad of tasks daily, many of which have to be repeated over and over again to massage complex information into a format that is easy to view and analyse. Hundreds of thousands of these Excel users have already tried everything that's doable via the user interface and are looking to extend Excel in a new direction that's custom-controllable. This book takes these people where they want to go by showing them the tools and providing them with skills for spreadsheet programming. 'Excel 2003 VBA Programming with XML and ASP' takes non-programmers through detailed steps of automating their spreadsheets. The book begins with recording a simple macro and exploring its code and proceeds to demonstrating in hands-on exercises the use of VBA language concepts.
After readers have mastered decision making, looping, and the usage of collections and arrays, they quickly move on to perform automating operations on files, folders, and other applications such as Word or Access. And that's not all. Readers also learn how to write VBA code to program pivot tables, generate charts, build dialog boxes, and design and customise menus and toolbars. They learn event programming and ways to handle errors and debug their programs. Some books finish at this point, however, this book goes on further -- all the way to the Web: creating hyperlinks with VBA, publishing worksheets, web charting, and using web queries to import web data. Using VBScript, HTML, Active Server Pages, and Extensible Markup Language is introduced step-by-step. The downloadable companion files include all the book's hands-on exercises and custom projects.