VBA Professional Projects

  • 8h 33m
  • Taruna Goel, et al.
  • Cengage Course PTR
  • 2002

Use VBA to accomplish real-world, professional tasks. Incorporating four hands-on projects, Microsoft VBA Professional Projects is your key to unlocking the power of Visual Basic for Applications. Each project focuses on a specific concept and is based on a real-world situation. You will be able to use the skills that you develop throughout the book to modify the projects as needed to fit your professional needs.

Create a Contacts Book Information: Create an application to store all the details from the Contacts folder in Outlook into a Word document. Enhance your skills as you work with forms and their properties, methods, and events. Throughout this project, you will gain an understanding of Outlook VBA programming, Outlook Object Model, and using OLE for Automation.

Create a Skill Search Application: Create an application that will search for details of employee skills based on the skills, years of experience, or employee names. Your application will display all matching documents as a list along with a hyperlink to the skill details, experience in the requested skillset, and the total experience. Throughout the project, you will learn to work with Visual Basic .NET and to deploy an application on the Web.

Create a Word Checker Tool: Create a tool to automate the procedure for proofreading a document against a specified style sheet. The tool you create will report all deviations from the standard style sheet in a separate document, highlighting incorrect words. While completing this project, you will enhance your skills using Visual Basic .NET and working with Word Objects.

Create an Easy Selling Application: Create an application to store client-specific details for a salesman in an Access database. Your application will generate a proposal in Word, create an Excel report, and create a presentation in PowerPoint. In developing this application, you will gain an understanding of buidling using Visual Basic .NET. You will also work with Windows Forms in .NET and will learn the concept of shared members, properties, and methods as you work with data types, variables, functions, and procedures.

In this Book

  • VBA Professional Projects
  • Introduction
  • VBA Overview
  • Variables, Constants, and Expressions
  • Procedures, Functions, and Modules
  • Arrays and Programming Constructs
  • Debugging and Error-handling in VBA
  • Objects in VBA
  • Using Security Features in VBA
  • Project Case Study—Global Systems, Inc.
  • Creating the User Interface of the Application
  • Working with User Forms
  • Using Automation
  • Adding Functionality to the Contacts Book Application
  • Using the Contacts Book Application
  • Project Case Study—Red Sky IT Systems
  • Overview of the .NET Framework
  • Introduction to VB.NET
  • The Integrated Development Environment
  • Working with Databases by Using VB.NET and ADO.NET
  • Coding the Skill Search Application
  • Working with ASP.NET
  • Executing the Skill Search Application
  • Project Case Study—Writers and Editors Inc.
  • Working with Word Objects in VBA
  • Coding the Application
  • Executing the Word Checker Tool
  • Project Case Study—Perfect Stationery Inc.
  • Creating the Database
  • Designing the Forms of the Application
  • Working with Excel Objects
  • Working with PowerPoint Objects
  • Coding the Main Screen of the Easy Selling Application
  • Coding the Customers Screen of the Easy Selling Application
  • Coding the Issues Screen of the Easy Selling Application
  • Coding the Solutions Screen of the Easy Selling Application
  • Coding the Outputs Screen of the Easy Selling Application
  • Executing the Easy Selling Application
  • XML and .NET
SHOW MORE
FREE ACCESS