Skip to Content
Office® XP Development with VBA
book

Office® XP Development with VBA

by Peter G. Aitken
September 2001
Beginner
528 pages
11h 59m
English
Pearson

Overview

  • Create custom business solutions with Microsoft Office XP and Office 2000!

  • Extend Word, Excel, Outlook, and other Office applications.

  • Learn all aspects of Office development, including security and distribution.

  • Leverage Office's powerful collaboration, intranet, and Web capabilities

  • For novice developers and Office power users!

  • Discover the power of Office programming

  • Applies to both Office XP and Office 2000

  • Master the Visual Basic for Applications (VBA) language and development environment

  • Understand the powerful components in the Office object model

  • Build custom tools that leverage email and the Web

  • Construct four Office applications - step-by-step

  • No Microsoft Office programming experience necessary!

  • Developing robust custom solutions with Microsoft Office XP/2000!Microsoft Office is far more than the world's leading office productivity suite. Itspowerful capabilities are organized into hundreds of programmable components, all available to any developer who needs to create custom business solutions. Bycombining these components with the powerful Visual Basic for Applications (VBA) programming language, you can construct powerful applications far more quickly than if you built them from scratch. These components and VBA are available in both Office XP and Office 2000, which means you can use them whether or not you upgraded.

    In this book, expert developer and consultant Peter G. Aitken shows exactly how toleverage the power of Microsoft Office in custom application development. Whetheryou're an experienced developer or a business professional with a problem that needssolving, Aitken will show you how to do it with Office — step by step.

    Aitken begins by reviewing each key Office application - Word, Excel, Access,PowerPoint, Frontpage, and Outlook - and the shared components accessible to all ofthem. You'll discover powerful opportunities for extending and automating Office to increase efficiency and improve collaboration throughout your organization. Then, onestep at a time, Aitken teaches the key VBA skills you'll need to achieve your goals. Finally, this book walks you through the construction of four real-world Office applications, emphasizing the potential value of Office custom solutions in real-world business situations.

    Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
    and much more.

    Read now

    Unlock full access

    More than 5,000 organizations count on O’Reilly

    AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

    QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
    Julian F.
    Head of Cybersecurity
    QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
    Addison B.
    Field Engineer
    QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
    Amir M.
    Data Platform Tech Lead
    QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
    Mark W.
    Embedded Software Engineer

    You might also like

    Excel® 2007 VBA Programmer's Reference

    Excel® 2007 VBA Programmer's Reference

    John Green, Stephen Bullen, Rob Bovey, Michael Alexander
    Programming in the .NET Environment

    Programming in the .NET Environment

    Damien Watkins, Mark Hammond, Brad Abrams
    Excel 2003 VBA Programmer's Reference

    Excel 2003 VBA Programmer's Reference

    Paul T. Kimmel, Stephen Bullen, John Green, Rob Bovey, Robert Rosenberg

    Publisher Resources

    ISBN: 0130654175Purchase book