Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Visual Basic for Applications Unleashed

Buy
Other Office products were slowly brought into the VBA fold, but it’s only with the release of Office 97 that Microsoft has finally achieved its goal. Now all of the Big Four—Word, Excel, Access, and PowerPoint—have a VBA development environment at their core. Not only that, but just about everything in the Office 97 package is programmable: Outlook, Office Binder, even the Office Assistant.

But unprecedented programmatic control over Office objects is only the beginning. Microsoft is now licensing VBA as a separate product—called VBA 5.0—that other companies can incorporate into their own applications. A number of developers have leaped willingly onto the VBA 5.0 bandwagon, including such heavyweights as Adobe, Autodesk, Micrografx, and Visio. And as if that weren’t enough, Microsoft has also created a version of VBA—called VBScript—that programmers can use as a scripting tool for Web pages.

There is little doubt, then, that VBA plays a huge role in Microsoft’s future plans. Anyone interested in truly unleashing the power of the Office applications, other programs, and Web pages will need to learn the VBA language. The good news is that VBA combines both power and ease of use. So even if you’ve never programmed before, you won’t find it hard to create useful procedures that let your applications perform as they never have before.

I’ve tried to keep the chapters focused on the topic at hand and unburdened with long-winded theoretical discussions. For the most part, each chapter gets right down to brass tacks without much fuss and bother. To keep the chapters uncluttered, I’ve made a few assumptions about what you know and don’t know:
  • I assume you have knowledge of rudimentary computer concepts such as files and folders.
  • I assume you’re familiar with Windows and that you know how to launch applications and use accessories such as Control Panel.
  • I assume you’re comfortable with the basic Windows 95 interface. This book doesn’t tell you how to work with tools such as menus, dialog boxes, and the Help system.
  • I assume you can operate peripherals attached to your computer, such as the keyboard, mouse, printer, and modem.
  • I assume you’ve installed VBA 5.0 (via Office 97 or some other VBA-enabled application) and are ready to dive in at a moment’s notice.
  • Most of this book’s examples involve Office 97. Therefore, I assume you’ve used the Office programs for a while and are comfortable working with these programs.
  • I assume you have a brain and are willing to use it.
About the Author
Paul McFedries is a computer consultant, programmer, and freelance writer. He has worked with computers in one form or another since 1975, he has a degree in mathematics, and he can swap out a hard drive in seconds flat—yet still, inexplicably, he has a life. McFedries is the author or coauthor of more than two dozen computer books that have sold over 900,000 copies worldwide. His titles include Paul McFedries’ Windows 95 Unleashed, Microsoft Office 97 Unleashed, and Navigating the Internet, all from Sams Publishing.

Other hats worn by McFedries on occasion include video editor, animator, bread maker, Webmaster, brewmaster, cruciverbalist, and neologist. He has no cats, and his favorite hobbies are shooting pool, taking naps, riding his motorcycle, and talking about himself in the third person.
(HTML tags aren't allowed.)

Programming Language Processors in Java: Compilers and Interpreters
Programming Language Processors in Java: Compilers and Interpreters

This book provides a gently paced introduction to techniques for implementing programming languages by means of compilers and interpreters, using the object-oriented programming language Java. The book aims to exemplify good software engineering principles at the same time as explaining the specific techniques needed to build compilers and...

JUnit in Action, Second Edition
JUnit in Action, Second Edition

When JUnit was first introduced a decade ago by Kent Beck and Erich Gamma, the Agile movement was in its infancy, "Test Driven Development" was unknown, and unit testing was just starting to move into the typical developer's vocabulary. Today, most developers acknowledge the benefits of unit testing and rely on the...

Customer Success with Microsoft Dynamics Sure Step
Customer Success with Microsoft Dynamics Sure Step

Having invested in Microsoft Dynamics, your enterprise will want to make a success of it, which is where this guide to Sure Step comes in, teaching you how to apply the methodologies to ensure optimum results.

Overview

  • Understand how Sure Step helps you envision and implement the right Microsoft Dynamics...

Prototyping Essentials with Axure
Prototyping Essentials with Axure

A comprehensive strategy and planning guide for the production of world-class UX artifacts such as annotated wireframes, immersive prototypes, and detailed documentation with this book and ebook

Overview

  • Learn in a progressive and structured way to plan and construct highly compelling interactive,...
Adobe Edge Animate Preview 7: The Missing Manual
Adobe Edge Animate Preview 7: The Missing Manual
It may be hard to imagine, but once upon a time, pages on the World Wide Web didn’t have pictures, let alone animations, videos, and interactive graphics. All these elements were added through trial, error, debate, and debunk. Changes came when brave souls (like you) forged ahead and made things work with the...
Learning Informatica PowerCenter 9.x
Learning Informatica PowerCenter 9.x

Learn the art of extracting data from disparate systems, integrating it using the leading data integration platform, and creating intelligent data centers for your business

About This Book

  • Learn the functionalities of each component in the Informatica PowerCenter tool and deploy them to accomplish...
©2021 LearnIT (support@pdfchm.net) - Privacy Policy