Explore the vast range of titles available.

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.Offers an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA)Features invaluable advice from “Mr. Spreadsheet” himself (bestselling author John Walkenbach), who demonstrates all the techniques you need to create large and small Excel applicationsProvides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you won't find anywhere elseIncludes a CD with templates and worksheets from the bookThis 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.

Intermediate and advanced coverage of Visual Basic 2010 and .NET 4 for professional developers If you've already covered the basics and want to dive deep into VB and .NET topics that professional programmers use most, this is your book. You'll find a quick review of introductory topics-always helpful-before the author team of experts moves you quickly into such topics as data access with ADO.NET, Language Integrated Query (LINQ), security, ASP.NET web programming with Visual Basic, Windows workflow, threading, and more. You'll explore all the new features of Visual Basic 2010 as well as all the essential functions that you need, including .NET features such as LINQ to SQL, LINQ to XML, WCF, and more. Plus, you'll examine exception handling and debugging, Visual Studio features, and ASP.NET web programming. Expert author team helps you master the tools and techniques you need most for professional programming Reviews why Visual Basic 2010 will be synonymous with writing code in Visual Studio 2010 Focuses on .NET features such as LINQ, LINQ to SQL, LINQ to XML, WPF, workflow, and more Discusses exception handling and debugging, data access with ADO.NET, Visual Studio features for Visual Basic developers, Windows programming with Windows Forms, ASP.NET web programming with VB, communication interfaces, Windows workflow, and threading This Wrox guide presents you with updated coverage on topics you need to know now.

Often financial computing guidebooks provide only quick-and-dirty implementations of financial models, rarely related to real-world applications.Professional Financial Computing Using Excel and VBA provides reusable, flexible, real-world implementations of financial models.

Updated for Access 2016 and based on the bestselling editions from previous versions, Microsoft Access 2016 Programming by Example with VBA, XML and ASP is a practical how-to book on Access programming, suitable for readers already proficient with the Access user interface (UI). If you are looking to automate Access routine tasks, this book will progressively introduce you to programming concepts via numerous illustrated hands-on exercises. More advanced topics are demonstrated via custom projects. Includes a comprehensive disc with source code, supplemental files, and color screen captures (Also available from the publisher for download by writing to info@merclearning.com). With concise and straightforward explanations, you learn how to write and test your programming code with the built-in Visual Basic Editor; understand and use common VBA programming structures such as conditions, loops, arrays, and collections; code a message box ; reprogram characteristics of a database; and use various techniques to query and manipulate your Access .mdb and .accdb databases. The book shows you how you can build database solutions with Data Access Objects (DAO) and ActiveX Data Objects (ADO); define database objects and manage database security with SQL; enhance and alter the way users interact with database applications with Ribbon customizations and event programming in forms and reports. You also learn how to program Microsoft Access databases for Internet access with Active Server Pages (Classic ASP), HTML, and XML. Features: + Contains over thirty chapters loaded with illustrated Hands-On exercises and projects that guide you through the VBA programming language. Each example tells you exactly where to enter code and how to test it and then run it. + Includes a comprehensive disc with source code, supplemental files, and color screen captures (Also available from the publisher for download by writing to info@merclearning.com). + Explains how to store data for further manipulation in variables, arrays, and collections while teaching you to write both simple and complex VBA programming routines and functions. + Teaches you how to programmatically create and access database tables and fields. + Shows you how to insert, update, and delete data via programming code using various data access techniques. + Gets you proficient creating and running simple and parameterized queries against your Access databases. + Gets you comfortable using external data sources with Access (Excel, Word, flat files, XML, and SQL Server). + Teaches you how to take control of your forms and reports by writing programming code known as event procedures. + Shows you how to use various types of macros and templates. + Takes your programming skills to the Web by introducing you to dynamic XML and Classic ASP pages.On the disc:(Also available from the publisher for download by writing to info@merclearning.com). + All source code and supplemental files for the Hands-On exercises and custom projects + All images from the text (including 4-color screenshots)

Its power and short learning curve have made Access Microsoft's leading consumer relational database management system for desktop applications. VBA lets you tap more of that power, responding to application level events, displaying forms and reports, manipulating toolbars, and much more. In this book, a crack team of programmers including two Microsoft MVPs shows you how to take control of Access 2003 or 2002 using VBA. You'll learn to create and name variables, use DAO and ADO to manipulate data, handle errors correctly, create classes and use APIs, and more. An entire chapter is devoted to the changes in Access 2003, including new wizards and GUI features that previously required VBA code as well as new VBA features. You'll receive a thorough education in system security, macro security, and the Access Developer Extensions (ADE). You will discover how to access data with VBA, execute and debug VBA code, and use VBA with Access objects. Finally, you will learn more about the relationship between Access and SQL Server®, and how to use VBA in Access to control and enhance other Office applications. What you will learn from this book How to take advantage of the built-in Access object library, using Access commands and executing them from any Access toolbar What you need to know to design your own classes, implement common APIs in your code, and use SQL to access data How to configure custom menus for your Access database applications Ways to transfer information between Access and Excel, Word, Outlook®, and other Office programs How to show or hide entire sections of reports based on data entered on a form, or hide form fields based on database login information Object models you can use when writing VBA code in Access, and a list of common API functions to use in your code Who this book is for This book is a comprehensive resource for Access users and VBA developers who want to increase the power of Access using VBA. In addition to experience with VBA, you should have read at least one tutorial covering VBA for Access. Wrox Programmer's References are designed to give the experienced developer straight facts on a new technology, without hype or unnecessary explanations. They deliver hard information with plenty of practical examples to help you apply new tools to your development projects today.