R
Ramone
Hi. I am about to start my first Visio project (business process modeling
tool) but don't have the experience necessary to decide whether I should
code via VBA, Add-in or Add-on. So hopefully, someone can help me out.
I have read "About Microsoft Visio Add-ons and COM Add-ins"
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvisio02/html/visaddin.asp
but it hasn't pointed me to one architecture or another.
The plan...
- drawings will contain 200-1000 shapes (40-200 groups) from a 30-shape
stencil already created
- drawings will take care of the visual aspects of the business process
while a database will store all the logic (activities, decision points,
resourses used, etc.) so that I can write code to do statistical analysis
and reporting.
I need to be able to...
- add a menu to Visio
- navigate between drawings (drill-up/drill-down on specific shapes)
- open tabbed forms to edit attributes of shapes, everytime I drag and drop
a shape in a document or right-click on a shape already added. These
attributes will be chosen from existing database values or create new DB
entries
- group shapes together if one is dropped on top of another (and make
appropriate DB changes)
- support complex rules of which shapes can be interconnected (type,
cardinality, directionality)
- modify shapes (text, color, size, position, etc.) based on properties that
the user changes
- run code to check that everything in the drawing conforms to rules I have
setup (e.g. no arrows unconnected, no orphan nodes, etc.) and that there are
no conflicts between drawings (DB values)
My concerns are...
- speed
- ability to hide the source code
- centralization of the code (don't want old code in old drawings)
- ease of programmability (I have a good grasp of VBA but don't know about
any Add-in/Add-on complications)
So, my question remains: should I proceed via VBA, Add-in or Add-on? Any
help would be greatly appreciated!
Ramone
tool) but don't have the experience necessary to decide whether I should
code via VBA, Add-in or Add-on. So hopefully, someone can help me out.
I have read "About Microsoft Visio Add-ons and COM Add-ins"
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvisio02/html/visaddin.asp
but it hasn't pointed me to one architecture or another.
The plan...
- drawings will contain 200-1000 shapes (40-200 groups) from a 30-shape
stencil already created
- drawings will take care of the visual aspects of the business process
while a database will store all the logic (activities, decision points,
resourses used, etc.) so that I can write code to do statistical analysis
and reporting.
I need to be able to...
- add a menu to Visio
- navigate between drawings (drill-up/drill-down on specific shapes)
- open tabbed forms to edit attributes of shapes, everytime I drag and drop
a shape in a document or right-click on a shape already added. These
attributes will be chosen from existing database values or create new DB
entries
- group shapes together if one is dropped on top of another (and make
appropriate DB changes)
- support complex rules of which shapes can be interconnected (type,
cardinality, directionality)
- modify shapes (text, color, size, position, etc.) based on properties that
the user changes
- run code to check that everything in the drawing conforms to rules I have
setup (e.g. no arrows unconnected, no orphan nodes, etc.) and that there are
no conflicts between drawings (DB values)
My concerns are...
- speed
- ability to hide the source code
- centralization of the code (don't want old code in old drawings)
- ease of programmability (I have a good grasp of VBA but don't know about
any Add-in/Add-on complications)
So, my question remains: should I proceed via VBA, Add-in or Add-on? Any
help would be greatly appreciated!
Ramone