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

  • Article
Calling Code in an Add-in from VBA Video How To

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

MS Help WorkshopTOC Folder icon Visual Studio Videos

MS Help WorkshopTOC Folder icon Visual Studio Tools for Office Videos

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

link to videoVideo How to: Binding Content Controls to Custom XML Parts

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

link to videoVideo How to: Deploy an Office Solution by Using ClickOnce (2007 System)

link to videoVideo How to: Designing an Outlook Form Region

Other Videos

Additional Help Resources