Publisher's Synopsis
Book and CD. 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 customize 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. Includes CD with downloadable files which include all the book's hands-on exercises and custom projects.