Video How to: Calling Code in an Application-Level Add-in from VBA

Authors: Harry Miller, Kathleen McGrath, McLean Schofield, Microsoft Corporation Applies to: Microsoft Visual Studio 2008 Professional Edition Length: 00:04:20 | Size: 21.0 MB | Type: WMV file   Watch the video Download the video and transcript Read the step-by-step article

Video Summary

You can expose an object in an application-level add-in to other Microsoft Office solutions, including Visual Basic for Applications (VBA) solutions and COM add-ins.

This video shows you how to write a method in an add-in for Microsoft Office Excel 2007 that you can call from VBA code in the workbook. The following tasks are included in the process:

• Defining a class that can be exposed to other Office solutions.

• Exposing the class to other Office solutions.

• Calling a method of the class from VBA code.

The Visual Studio Tools for Office Help includes the code and the steps that are demonstrated in this video. See Walkthrough: Calling Code in an Application-Level Add-in from VBA.

Additional Video Resources

Video How Tos

 Visual Studio Videos

 Visual Studio Tools for Office Videos

Video How to: Add or Remove Inclusion List Entries (2007 System)

Video How to: Creating a Custom Tab by Using the Ribbon Designer

Other Videos

• Visual Studio Tools for Office How Do I Video Series

• Visual Studio Tools for Office Visual How Tos

Additional Help Resources

• Calling Code in Application-Level Add-ins from Other Office Solutions

• Programming Application-Level Add-Ins

• Calling Code in Document-Level Customizations from VBA

• How Do I in Visual Studio Tools for Office