Experienced Excel users learn how to exercise the full power of Excel--create timesaving, productivity-enhancing macros based on Visual Basic for Applications (VBA) and write code in VBA. The CD-ROM contains examples and reusable code from the book, and share- and freeware.
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.
Learn how to create elegant user interfaces and develop fast, user-friendly applications for your stand-alone version of Access while reaping the benefits of new capabilities. The CD-ROM contains the book's sample databases, reusable forms, and freeware and shareware utilities.
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.
With detailed technical information delivered straight from the Microsoft Office 2000 documentation team, this practical and precise guide offers hands-on detail for everything from planning and developing Office 2000 solutions, working with data, designing multiuser solutions, and distribution.
Oracle Forms is the single most important tool used to create sophisticated applications for Oracle databases. The latest versions of Oracle Forms have reflected Oracle's Internet-centered strategy, adding powerful capabilities for building Web-centered applications to the product's traditional client/server focus. In Oracle Forms Developer's Handbook, one of the world's leading Oracle developers presents powerful techniques for leveraging Oracle Forms in both web-centered and client/server environments. This is the first Oracle Forms book to reflect the brand-new Version 6i. Oracle Forms Developer's Handbook starts by presenting step-by-step instructions for using every tool in the Forms environment, including the Forms Designer, Object Navigator, and the Layout Editor. Next, learn how to use PL/SQL in Forms applications; master all of the methods and objects available to Forms programmers; and learn how to apply object-oriented programming practices to Forms development, including inheritance, reusability, encapsulation, and polymorphism. Then, walk step-by-step through developing a series of complete, elegant, well-performing Web-based and client/server applications. An accompanying CD-ROM contains all of the book's applications and source code examples, plus all files needed to create and populate sample database objects -- enabling readers to start from any chapter and follow the hands-on activities.
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.
VBA is used for writing macros, automating Office applications, and creating custom applications in Word, Excel, PowerPoint, Outlook, and Access Easily accessible by novice programmers, VBA is also powerful enough for IT professionals who need to create specialized business applications, generating wide interest Completely revised for the new versions of the language and the Office suite, this book is the most up-to-date VBA guide on the market Includes what everyone, from power users to system administrators and professional developers, needs to know Covers all Office products in depth
Your expert guide to building modern applications with Visual Basic 2010 Take control of Visual Basic 2010—for everything from basic Windows and web development to advanced multithreaded applications. Written by Visual Basic experts, this handbook provides an in-depth reference on language concepts and features, as well as scenario-based guidance for putting Visual Basic to work. It's ideal whether you’re creating new applications with Visual Basic 2010 or upgrading projects built with an earlier version of the language. Discover how to: Use Visual Basic 2010 for Windows Forms and Windows Presentation Foundation projects Build robust code using object-oriented programming techniques, such as classes and types Work with events and delegates—and add your own events to custom classes Program arrays, collections, and other data structures in the Microsoft .NET Framework Solve problems quickly and easily using My namespace in Visual Basic Dive into Microsoft LINQ, including LINQ to XML and LINQ to Entities Tackle threading, multitasking, and multiprocessor development and debugging
This one-of-a-kind reference explains the XML standard, how to create XML documents, and how XML will transform legacy systems integration involving e-commerce initiatives. As more corporations migrate to an eBusiness model using Oracle8i--THE database for Internet computing--it's crucial for all Web developers to learn to use XML in the Oracle environment. This book shows you how.