+ Reply to Thread
Results 1 to 2 of 2

How to access Add-in module from VBA macro

  1. #1
    Registered User
    Join Date
    12-08-2011
    Location
    York,PA
    MS-Off Ver
    Excel 2007
    Posts
    2

    How to access Add-in module from VBA macro

    I have created an Excel Add-in using VS2010 using C#. Inside the ThisAddIn class, along with the Startup and Shutdown events, I have added a function, AddMapping - which essentially sets up an XML mapping to a worksheet. I want to trigger this function from inside a VBA macro inside a loaded spreadheet - how do I access this function in the Add-in module - I do not see the Add-In module in the Project Explorer when VBA is up - as per this

    I'm very new to Add-ins - I believe this has created a COM add-in - not sure if that has anything to do with it.

    Thanks for any help
    Last edited by tweaver1960; 12-09-2011 at 06:29 AM.

  2. #2
    Registered User
    Join Date
    12-08-2011
    Location
    York,PA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: How to access Add-in module from VBA macro

    Figured it out - stumbled upon this article/video here

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1