Even if you're not a programmer, you can quickly learn to write macros, automate tasks, and create custom applications for Office 2007 with Microsoft'sVisual Basic for Applications (VBA) and the in-depth instruction in this comprehensive guide. You'll jump right into the basics of recording and running macros with Office's built-in Macro Recorder, before quickly moving to the essentials of VBA syntax, using loops and functions, building effective code, and programming applications in Word, Excel, PowerPoint, Outlook, and Access. Includes pages of real-world examples and techniques.

A unique, comprehensive guide to creating custom apps withVBA Automating computing tasks to increase productivity is a goalfor businesses of all sizes. Visual Basic for Applications (VBA) isa version of Visual Basic designed to be easily understandable fornovice programmers, but still powerful enough for IT professionalswho need to create specialized business applications. With thisinvaluable book, you'll learn how to extend the capabilities ofOffice 2013 applications with VBA programming and use it forwriting macros, automating Office applications, and creating customapplications in Word, Excel, PowerPoint, Outlook, and Access. Covers the basics of VBA in clear, systematic tutorials andincludes intermediate and advanced content for experienced VBdevelopers Explores recording macros and getting started with VBA;learning how to work with VBA; using loops and functions; usingmessage boxes, input boxes, and dialog boxes; creating effectivecode; XML-based files, ActiveX, the developer tab, contentcontrols, add-ins, embedded macros, and security Anchors the content with solid, real-world projects in Word,Excel, Outlook, PowerPoint, and Access Covering VBA for the entire suite of Office 2013 applications,Mastering VBA for Microsoft Office 2013 is mandatoryreading.

Many Microsoft Word users and VBA programmers don't realize the extensive opportunities that exist when Word's object model is accessed using Visual Basic for Applications (VBA). By creating what is commonly called a "Word macro," you can automate many features available in Word. Writing Word Macros (previously titled Learning Word Programming) is the introduction to Word VBA that allows you to do these things and more. Book jacket.

Your hands-on, step-by-step guide to learning Visual Basic 2010. Teach yourself the essential tools and techniques for Visual Basic 2010-one step at a time. No matter what your skill level, you'll find the practical guidance and examples you need to start building professional applications for Windows and the Web. Discover how to: Work in the Microsoft Visual Studio 2010 Integrated Development Environment (IDE) Master essential techniques-from managing data and variables to using inheritance and dialog boxes Create professional-looking Uis; add visual effects and print support Build compelling Web features with the Visual Web Developer tool Use Microsoft ADO.NET and advanced data presentation controls Debug your programs and handle run-time errors Use new features, such as Query Builder, and Microsoft .NET Framework For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

Provides a step-by-step guide to using Visual Basic for Applications (VBA) and macros to import data and produce reports in Microsoft Excel 2010.

Step-by-step instructions for creating VBA macros Harness the power of VBA and create custom Excel applications Make Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more. Discover how to Grasp essential programming concepts Use the Visual Basic Editor Navigate the new Excel user interface Communicate with your users Deal with errors and bugs

Boost productivity and streamline your workflow with expert AutoCAD: VBA programming instruction AutoCAD Platform Customization: VBA is the definitive guide to personalizing AutoCAD and the various programs that run on the AutoCAD platform, including AutoCAD Architecture, Civil 3D, Plant 3D, and more. Written by an Autodesk insider with years of customization and programming experience, this book features detailed discussions backed by real-world examples and easy-to-follow tutorials that illustrate each step in the personalization process. Readers gain expert guidance toward managing layouts and external references, changing the menu and other interface items, creating forms, and communicating with Office applications—all designed to streamline the workspace and improve productivity. An additional resources appendix, downloadable datasets, and customization examples provide extra information and tools that allow users to implement the most advanced customizations. Autodesk's AutoCAD platform is the basis for much of the software that is integral to the modern design and engineering processes. VBA allows users to customize the AutoCAD interface and other features to increase screen real estate, create macros, validate drawing information, and more, leaving less repetition, fewer distractions, and more time for design. AutoCAD Platform Customization: VBA walks readers through the many options available, teaching them to: Create, modify, annotate, and view drawing objects Interact comfortably with the application, open documents, and the user Manage external data, communicate with other applications, and define user forms Debug custom programs and handle errors Customization allows users to keep their favorite tools at their fingertips, and put away the ones they don't need. For AutoCAD users looking to streamline their workflow, AutoCAD Platform Customization: VBA provides expert instruction and insider advice.