Our customer wants us to develop a dashboard system to be viewed using ActiveView. I am creating some demo / prototype dashboards using VBA at the moment but would like to do it in a neater fashion if possible. I was wondering what the ActiveView implications would be of developing the dashboard creation code as a ProcessBook addin.
The advantages that I can see are:
- I get to code in a better development environment and language of my choice (VBA has many shortcomings, C# and VB .NET are both superior)
- The code to generate the displays can be separate from the displays themselves
The disadvantages are:
- I am not as familiar with writing addins as I am with VBA, although I have access to the webinars and VS2005 addin templates.
- I do not know if ActiveView is compatible with addins.
Does activeviewsupport Processbook addins? If not the display creation could be done in PB by an addin for viewing separately in ActiveView but custom behaviour would still have to be created as VBA modules. Could an addin create VBA code modules in the display to implement any custom behaviour? I know I have experienced problems trying to get PB VBA to write code modules since the module being written gets parsed before it is complete and the whole thing falls over. Can an addin get around this by putting PB into build mode while it creates modules?