CODEWITHSUNDEEP
c#vbacominteropeditor
almog.ori
almog.ori

Reputation: 7889

vba Extentiblity, com addin guidance?

Does anyone know of good reference material for creating a com addin for the VBA Editor enviroment, i know its exactly the same as writing a com addin for common enviroments using the addin model provided by microsoft using the IDTExtensibility2 interface. just registering the com registry keys to a different location, Where is that location?

Also any examples on .net interop code for how to reference the code editor, in as much detail as possible, add custom menu items to the context menu. you know normal customization code. Also if anyone knows how to hook up visual studio for debugging said project. If you know of anyone of these, id be very much indebted.

Upvotes: 2

Views: 389

Answers (4)

Michael Paulukonis
Michael Paulukonis

Reputation: 9100

Check out O'Reilly's Developing Visual Basic Add-ins: The VB IDE Extensibility Model

The book, while an excellent resource, is mostly based on the normal VB Editor -- but combined with digging through the Object Browser, and references like those @ MzTools (as Jon pointed out), you should be good to go.

I used both of these resources when dealing with the VBA IDEin EMC-Captiva's InputAccel and FormWare environments, which only expose portions of the VBA IDE.

Upvotes: 1

Jon Fournier
Jon Fournier

Reputation: 4327

It looks like the person who put together the MZ Tools has a small section on their site with some resources on building VBE Addins

http://www.mztools.com/resources_vs60_addins.aspx

Upvotes: 2

Tom Juergens
Tom Juergens

Reputation: 4592

"Microsoft Office 2000 Visual Basic Programmer's Handbook" (ISBN 3-86063-289-2) has four (!) pages on this subject. I only have the German edition, but I could translate the important bits if you think it might help. Obviously, nothing about .Net Interop in there, but some basic info about writing VBE Add-ins.

Upvotes: 1

shahkalpesh
shahkalpesh

Reputation: 33474

This could be the registry location - HKCU\Software\Microsoft\VBA\VBE\6.0\Addins

I found this by running Process Monitor from sysinternals.

Capture Events using Process Monitor
Ran Excel, Alt+F11, Tools -> Addins

EDIT: I don't know much about .net interoping with addin code.

But, I would open the addin project, set the necessary breakpoints, keep it in run mode, open the VBA editor, load the addin & take actions which will make me break into the code of the addin.

Upvotes: 1

Related Questions