Sams Teach Yourself Microsoft Excel 2000 Programming in 24 Hours

Written by a Microsoft Certified Trainer, this book teaches techniques that enable the reader to automate common tasks in Excel, in 24 one-hour lessons. In addition, it demonstrates how to fully integrate Excel data into an Intranet or Internet Web site.

---

Sams Teach Yourself Excel 2000 Programming in 24 Hours begins by teaching you how to record and edit macros, and then focuses on creating small but powerful functions and subroutines. Coverage of modular programming and the creation of libraries and add-ins make this book a 'must-have' for any Excel power user or developer. Learn how to design, create, and debug programs written in the Visual Basic for Applications (VBA) programming language that is embedded within Microsoft Excel 2000. Learn how to use VBA macros and programs, or translate your existing programming or macro writing skills to the VBA language and environment. Topics include: macro recording and editing, automating tasks within Excel, creating new Excel functions, importing and exporting data, customizing Excel's toolbars and menus, and more.