VBA Developer's Handbook


Book Description

WRITE BULLETPROOF VBA CODE FOR ANY SITUATION This book is the essential resource for developers working withany of the more than 300 products that employ the Visual Basic forApplications programming language. Written by recognized VBAexperts, it provides detailed coverage of a wide range of specificVBA programming challenges. Its careful, step-by-step instructionsand thousands of lines of code offer answers, while teaching you todevise new and creative solutions. The instruction applies equallyto all VBA environments, whether you are building standaloneapplications or customizing commercial products using theirbuilt-in VBA programmability. Coverage Includes Manipulating text, numbers, and dates Using automation to control other applications Creating objects using VBA class modules Using standard search and sort algorithms from within VBA Creating standard dynamic data structures, including linkedlists, binary trees, stacks, and queues Working with Windows system information, including memorystatus, screen info, mouse, keyboard, and power status Working with Windows Registry data Retrieving and setting Windows networking information Working with the Windows file system, iterating throughfolders, creating and deleting files Adding sound and movies to VBA apps using Windows multimediaextensions Tapping the system capabilities provided by the WindowsScripting Runtime library Writing add-ins for the Visual Basic environment Note: CD-ROM/DVD and other supplementary materials arenot included as part of eBook file.




VBA developer's handbook


Book Description




Visual Basic Language Developer's Handbook


Book Description

This follow-up to the successful "VBA Developer's Handbook" is a significant revision because it targets a much broader audience and focuses on all the new, improved programming techniques that aren't available from any other source. The book and CD include hundreds of reusable functions and classes that readers can use in their own programming projects with little or no modification.




Access 2003 VBA Programmer's Reference


Book Description

What is this book about? 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 does this book cover? Here are some of the things you'll discover in 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 is this book 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.




Access 2002 VBA Handbook


Book Description

How Far Can You Go with Access 2002? The answer depends on your knowledge of VBA programming. If you really want to get the most out of Access, the Access 2002 VBA Handbook is essential reading. If you are an experienced user of Access, you get the step-by-step instruction you need to be dramatically more productive. And if you are a more experienced developer, you get the advanced VBA programming skills you need to build the Access applications your users require. Coverage includes * Running queries to find specific records * Automating complex and time-consuming procedures * Importing data from existing data sources * Synchronizing forms and tables * Understanding the ADO and DAO models * Understanding the essentials of Visual Basic for Applications (VBA) * Customizing the Access user interface * Creating procedures to change Access's default error-handling processes * Accessing data using OLE DB and ODBC * Creating VBA procedures for navigating a database or project * Writing VBA procedures using object properties and methods * Creating relationships between forms * Executing commands using SQL statements in VBA code * Using ActiveX controls in your VBA procedures




Microsoft Excel 97 Developer's Handbook


Book Description

Organizations everywhere are discovering that Microsoft Excel is a powerful development tool--and now features important Intranet and Internet capabilities. That's why the third edition of this classic is the one-volume reference for application programmers who want fast, easy ways to produce custom business information solutions.




Mastering VBA for Office 2010


Book Description

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. Office 2010 is the leading productivity suite, and the VBA language enables customizations of all the Office programs; this complete guide gives both novice and experienced programmers the knowledge they need to make maximum use of VBA for Office Supported with real-world examples in Word, Excel, PowerPoint, Outlook, and Access, this book offers clear, systematic tutorials with both intermediate and advanced content Covers learning how to work with VBA; recording macros; using loops and functions; using message boxes, input boxes, and dialog boxes; creating effective code; XML-based files; ActiveX; the developer tab; content controls; add-ins; embedded macros; and security Mastering VBA for Office 2010 prepares developers to customize all Microsoft Office 2010 applications for the unique needs of their employers.







Microsoft Outlook Programming


Book Description

-- A one-minute-manager approach to issues-- Explanation of how following each principle can save money or time-- Step-by-step instructions on how to accomplish objectives This book shows people how to overcome the social crisis that has resulted from the wide-spread use of information technology by responsibly managing security threats, protecting individual privacy, reducing hazardous waste, and minimizing other negative effects on IT staff and computer users, as well as ordinary citizens around the world.




Microsoft Access 97 Developer's Handbook


Book Description

This how-to book of custom applications shows how organizations can use Access 97 to develop effective information systems in less time, for less money. This is the one-volume reference that shows users how to automate tasks, do application programming, and integrate an Intranet or the Internet. The CD includes source files and developer tools.