Walkenbach John. Excel 2013 Power Programming with VBA

John Wiley & Sons, Inc., 2013. - 1104 pages. На англ. языке.Maximize your Excel 2013 experience using VBA application developmentThe new Excel 2013 boasts updated features, enhanced power, and new capabilities. Naturally, that means John Walkenbach returns with a new edition of his bestselling VBA Programming book and covers all the methods and tools you need to know in order to program with Excel. With this comprehensive guide, Mr. Spreadsheet shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf.Featuring a complete introduction to Visual Basic for Applications and fully updated for the latest features of Excel 2013, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel’s capabilities with VBA.
Offers an analysis of Excel application development and a complete introduction to VBA
Features invaluable advice from Mr. Spreadsheet himself, bestselling author John Walkenbach, who demonstrates all the techniques you need to create Excel applications, both large and small
Covers navigating the Excel interface, formatting worksheets, interacting with other Office applications, working with collaboration tools, and using sample workbooks and John Walkenbach’s award-winning Power Utility Pak to help enhance your Excel skills
Provides tips, tricks, and techniques for expanding Excel’s capabilities with VBA that you wont find anywhere elseExcel 2013 Power Programming with VBA is packed with procedures, tips, and ideas for achieving Excel excellence with VBA.Part I: Some Essential Background
Excel in a Nutshell
Formula Tricks and Techniques
Understanding Excel Files
Essentials of Spreadsheet Application Development
Part II: Understanding Visual Basic for Applications
Introducing Visual Basic for Applications
VBA Programming Fundamentals
Working with VBA Sub Procedures Chapter
8. Creating Function Procedures
VBA Programming Examples and Techniques
Part III: Working with UserForms
Custom Dialog Box Alternatives
Introducing UserForms
UserForm Examples
Advanced UserForm Techniques
Part IV: Advanced Programming Techniques
Developing Excel Utilities with VBA
Working with Pivot Tables
Working with Charts
Understanding Excel’s Events
Interacting with Other Applications
Creating and Using Add-Ins
Part V: Developing Applications
Working with the Ribbon
Working with Shortcut Menus
Providing Help for Your Applications
Developing User-Oriented Applications
Part VI: Other Topics
Compatibility Issues
Manipulating Files with VBA
Manipulating Visual Basic Components
Understanding Class Modules
Working with Colors
Frequently Asked Questions about Excel Programming
Part VII: Appendixes
Appendix A. VBA Statements and Functions Reference
Appendix B. VBA Error Codes
Appendix C. This Book’s WebsiteФормат книги совместим с iPAD и Amazon Kindle, на PC открывается многими бесплатными ридерами, например Cool Reader, Calibre, Adobe Digital Editions