General.- About this book, who it's for, and how it can be used.- What's New in Excel 2007.-Compatibility Issues.- Programming Ideas, Best Practise etc.- About VBA.-Introduction to VBA.- The Visual Basic Editor.- Recording Macros.- Objects, Properties, Methods and Events.- Subs, Functions and Variables.- Build In Functions.- Ways to Run Your Macro (Add Ins, Personal Workbook).- Debugging and Error Handling (Types of Errors).- Security Issues.- Class Modules.- Other Building Blocks.-Working with Worksheets, Workbooks and Directories.- Working with Ranges.- Logic and Loops.- Arrays and Collections.- Pivot Tables.- User Forms.- (More) User Interaction.- Graphs.- Reading and Writing to TXT, XML etc.- Manipulating VBA using VBA.- Miscellaneous.- Multi Language Pack.- The Ribbon and Customising.- Naming and Programming Conventions.- Interacting with Other MSO Programs.- FAQ.- A Couple of Applications.- Accounting.- Leitner Learning Tool.- SuDoKu.- Data Mining.- XML Futures.- Other Elements.- ADO and DAO.
