Excel style add-ins in Visio

[alexre1]

Hi All,

I apologize in advance if this question is stupid/obvious. I'm a fairly
experienced Excel/VBA developer, and this is my first foray into Visio.

I've just finished creating a VBA module which allows me to generate
SQL/DDL statements from a Visio Database Model Diagram
(Entity/relationship). I've also created a sub which adds two custom
command buttons (based on the above DDL generation) to the drawing
context menu, so that I can easily generate DDL for any specific
entity, as well as the entire model.

Now, if I was using excel, I could just save this file as an add-in,
load it, and the custom functionality would always be present from that
point onwards. What is the equivalent in Visio? I know that Visio has
"Add-ons", but I have no idea how to generate one. Is it possible to
create an add-on from VBA code? If not, are there any alternatives?

Thanks!
Alex

 

[JuneTheSecond]

Stencil might be an alternative. Save a drwaing as a stencil. Stencil can be
open on any drawing, and the VBA macro on the stensil can be run for the
drawing. You can also save as a template togather with a drawing.