developing a Visio based application

[lk123]

Could you help me to solve few questions.

I am developing a Visio based application. It will automatically
convert CAD drawings and let user select elements of the drawing. Then
number of the selected elements will be stored in a variable and then
passed to another application (Access) after clicking on pre-defined button.
Questions:
1. Is it possible to have the specified functionality within Visio?
2. How to create right-click functionality?
3. How to pass variable to Access?
4. How to create design-time buttons in Visio that will work throughout
the application?

 

[toblo]

1 - I'm sure it's possible
2 - Simple - just add script in the Actions-section of the shape's shapesheet (it will appear in the right-click menu), which can trigger anything you've written in VBA
3 - I guess you're just gonna 'send' a collection, right? -But what exactly do you mean by Sending? -Passing it as an argument to a VBA-function in your Excel-sheet should be pretty doable - Where is the conversion to take place?
4 - I thing the Developer's Guide contains some example of adding buttons in the bar, that are unique to every document handled - It works fine for me!

BTW - I recommend you put all of your code-stuff in a stencil which you can then use from any document.. I've been doing a lot of that, and it's pretty convenient

Good luck!
/toblo