All the methods and tools you need to successfully program with Excel
John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. 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 new features of Excel 2010, 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.
This power-user's guide is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA.
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
* This friendly, easy-to-use guide shows experienced Access users how to use
* VBA (Visual Basic for Applications) to build Access databases and applications, but also covers programming fundamentals for nonprogrammers
* Includes practical, ready-to-use VBA code examples that readers can type or copy and paste from the Web into their own database projects
* Explains basic VBA skills and concepts for nonprogrammers, such as procedures, variables, and loops
* Covers more advanced topics, such as record sets and other programming activities that are unique to Access programming
* Author has written more than ninety computer books and has been working with databases since the early 1980s
Maximize your Excel 2013 experience using VBA application development
The 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.
Excel 2013 Power Programming with VBA is packed with procedures, tips, and ideas for achieving Excel excellence with VBA.
VBA helps you put your computer in its place
Write programs that automate tasks and make Office 2007 work better for you
If your computer is becoming your boss instead of your servant, start using VBA to tell it what to do! Here's the latest on the VBA IDE and program containers, debugging and controlling your programs, working with multiple applications using a single program, and the most exciting stuff — programming for all the Office 2007 applications.
Discover how to
The online documentation of VB/VBA language components seems to follow the 80/20 rule: the basic facts that you need to use a language statement are provided in the documentation. But the additional 20 percent that you need to use it effectively or to apply it to special cases is conspicuously absent. To a professional VB/VBA programmer, though, this missing 20 percent of the language's documentation isn't a luxury, it's a necessity. And in VB & VBA in a Nutshell: The Language, it finally is available.
The bulk of the book consists of an alphabetical reference to the statements, procedures, and functions of the VB/VBA language. Each entry has a standardized listing containing the following information:
Also included in VB & VBA in a Nutshell: The Language is a brief overview of the VB/VBA language, including:
Designed for programmers, this desktop quick reference covers Visual Basic 5 & 6 and the hosted language Visual Basic for Applications (VBA). VBA is widely used as the binding glue between Microsoft office products and application technologies. To derive the most benefit from this reference, you should be familiar with VB, the Windows environment, the object model, VB basic structure and VB syntax.
A unique, comprehensive guide to creating custom apps with VBA
Automating computing tasks to increase productivity is a goal for businesses of all sizes. Visual Basic for Applications (VBA) is a version of Visual Basic designed to be easily understandable for novice programmers, but still powerful enough for IT professionals who need to create specialized business applications. With this invaluable book, you'll learn how to extend the capabilities of Office 2013 applications with VBA programming and use it for writing macros, automating Office applications, and creating custom applications in Word, Excel, PowerPoint, Outlook, and Access.
Covering VBA for the entire suite of Office 2013 applications, Mastering VBA for Microsoft Office 2013 is mandatory reading.
A comprehensive guide to the language used to customize Microsoft Office
Visual Basic for Applications (VBA) is the language used for writing macros, automating Office applications, and creating custom applications in Word, Excel, PowerPoint, Outlook, and Access. This complete guide shows both IT professionals and novice developers how to master VBA in order to customize the entire Office suite for specific business needs.
Mastering VBA for Office 2010 prepares developers to customize all Microsoft Office 2010 applications for the unique needs of their employers.
Now that you've mastered Excel basics, it's time to move to the next level—creating your own, customized Excel 2010 solutions using Visual Basic for Applications (VBA). The new edition of this non-threatening guide is your key to getting there. Using step-by-step instruction and the accessible, friendly For Dummies style, this practical book shows you how to use VBA, write macros, customize your Excel apps to look and work the way you want, avoid errors, and more.
The book's Web site provides all the programming examples from the book.
Create your own, custom Excel programs with this information-packed guide!
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
An updated look at the theory and practice of financial analysis and modeling
Financial Analysis and Modeling Using Excel and VBA, Second Edition presents a comprehensive approach to analyzing financial problems and developing simple to sophisticated financial models in all major areas of finance using Excel 2007 and VBA (as well as earlier versions of both). This expanded and fully updated guide reviews all the necessary financial theory and concepts, and walks you through a wide range of real-world financial problems and models that you can learn from, use for practice, and easily adapt for work and classroom use. A companion CD-ROM includes several useful modeling tools and fully working versions of all the models discussed in the book.
This comprehensive guide is an essential read for anyone who has to perform financial analysis or understand and implement financial models.
WRITE BULLETPROOF VBA CODE FOR ANY SITUATION
This book is the essential resource for developers working with any of the more than 300 products that employ the Visual Basic for Applications programming language. Written by recognized VBA experts, it provides detailed coverage of a wide range of specific VBA programming challenges. Its careful, step-by-step instructions and thousands of lines of code offer answers, while teaching you to devise new and creative solutions. The instruction applies equally to all VBA environments, whether you are building standalone applications or customizing commercial products using their built-in VBA programmability.
Coverage Includes
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
The authors of this book are two-thirds of the writing team that produced the bestselling Access Developer's Handbook. The book focuses on VBA for the entire Office Suite. Learning to use VBA as described in the book will enable developers to combine VBA, OLE Automation (Object Linking and Embedding), and ActiveX controls. The CD includes reusable code from the book, and third-party shareware and demos.
Next book list: Books to Learn How to Program in Scala >>