Beginning Excel 2007 VBA

Advanced Excel users will take a step higher with "Beginning Excel 2007 VBA: From Novice to Professional" by walking through practical, work-environment uses of Excel to discover all the advantages of VBA programming. You've no need for previous programming experience or knowledge of VBA, and author Tom Staneke will advise you on where VBA is most, and least, useful to use. Teaches professional Excel users the advantages of VBA programming Does not assume prior programming experience Focuses on practical, work-environment uses of Excel What you'll learn Learn how to work with directories, workbooks, worksheets, ranges, and cells in a flexible way. Discover alternatives to PivotTables. Master debugging, error handling, and logging. Learn how to create and use user forms. Become skilled at collaboration with other programs (Notes, etc.). Learn how to manipulate VBA modules. Who is this book for? This book is for professional Excel users who wish to take their expertise to the next level through basic VBA programming. About the Apress Beginning Series The Beginning series from Apress is the right choice to get the information you need to land that crucial entry-level job. These books will teach you a standard and important technology from the ground up because they are explicitly designed to take you from "novice to professional." You'll start your journey by seeing what you need to know--but without needless theory and filler. You'll build your skill set by learning how to put together real-world projects step by step. So whether your goal is your next career challenge or a new learning opportunity, the Beginning series from Apress will take you there--it is your trusted guidethrough unfamiliar territory Related Titles from Apress Beginning SharePoint with Excel: From Novice to Professional Excel 2007: Beyond the Manual Excel as Your Database A Complete Guide to Pivot Tables: A Visual Approach Definitive Guide to Excel VBA, Second Edition Beginning Excel What-If Data Analysis Tools: Getting Started with Goal Seek, Data Tables, Scenarios, and Solver