Launching the Visio Org Chart "Import" Command programmatically in VBa

Started by Rich_T, October 18, 2013, 06:58:13 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Rich_T

I am using Visio 2010 and request that the user launch the Org Chart Wizard via a userform at startup that displays the instructions (goto to the Org Chart tab, click on the Import Button).

1) Is there a way to start the "Import" button in vba code?

This not only starts the importing of the data from the external file but also kicks off the process to place and organize the shapes for the org chart. Once the import wizards is done, the org chart is displayed but in some cases the splits across pages is clunky.

2) Is it possible to provide some additional settings for the org chart wizard to make it do a better job splitting across pages?

If The wizard goes straight from file Import to displaying boxes.  I think what I was looking for is to be able to select some formatting options like "Veritical" boxes instead of "Horizontal" boxes.

3)  The Org Chart Wizard sometimes presents solutions that are several pages wide and "Resize to Fit" doesn't solve.  Any ideas how to improve this?