Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am using ArcGIS Desktop 10.0.

I need a way to execute an ArcGis-Addin ( from a MS-Access database form (VBA).

The problem is that there is no ESRI.ArcGIS.Desktop.Addin reference in VBA and the "pItem.Execute" method with the "pCmdBars.Find(pUID)" does not work with my Addin-Button.

I want to open the ArcMap.mxd file and perform a selection that shows the spatial data of my MS-Access database query.

The rest is not a problem (maybe!).

share|improve this question
Just to clear the question up, do you want to add a "button" inside Access that fires up ArcMap and performs some spatial selection? – MLowry Apr 24 '12 at 19:07

For VBA to be able to interop with .NET types they need to be made COM-visible which involves adding keys to the registry. The ArcGIS 10 add-in framework was designed to simplify the deployment of certain types of customizations that ESRI created .NET classes for, eliminating the need for registering them with COM.

If you need COM interop support (which you do if you want to use them from VBA), then you need to write a traditional COM component, not an add-in, and make the types you need to use from VBA COM-visible.

This article suggests how you may be able to manually convert an add-in to a COM component: Converting an ArcGIS Desktop add-in to an ArcGIS custom component

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.