Interactive Visio to .exe?

[lewispark101]

Hi There,

New to the forum so please let me know if there is any additional information I need to provide here....

I have been working on a Visio drawing (Data model) which is controlled by a user form with VBA. You can select different systems / entities within the model and have the selected entities and all related items highlighed in the diagram. I was wondering if there was any way I could package this as a simple .exe file to use when presenting etc? Rather than having to open the visio, open visual basic, then click the play button to start it off? Its to make it more useable for the client. Relatively new to VBA with Visio so any help would be greatly appreciated!

Thanks,
Lewis

[Yacine]

Hi Lewis,
to my knowledge there is no solution out of the box to transform a visio file into an exe.
MS provided for this purpose the activex visio drawing control, which you can insert into a form. But it does not run included VBA script.
The hosting application needs to provide this.
Here are some starting links:
http://www.visguy.com/2007/05/11/integrating-visio-2007-with-microsoft-technologies/
http://msdn.microsoft.com/en-us/library/office/aa168480%28v=office.11%29.aspx
http://www.mikeborozdin.com/post/Developing-Applications-for-Visio-with-Visual-Studio-%28Windows-Forms-WPF-XBAP%29.aspx

So basically it is certainly easier to open visio and do whatever is required.

[AndyW]

You could have your visio diagram run the vba when you open the document or tou could add a button to your Visio diagram that will run your macro when you click on it. If you have a link to your .vsd visit file, double clicking that will launch visio and open your diagram. If you really want an .exe, then you will have to use VB, c# etc and use the activex drawing control. This will still require Visio to be installed on the machine the .exe is to be run on.