ORgChart wizard steps Replicate in VBA

[igor_bnp]

Hi All,

I currently have Access database that contains all my headcount and I use Visio OrgChart Wizard to create an org chart. I would like to be able to record a macro to do this for me but macro recorder does not seem to do anything.

I have found here a statement that pulls the interface but again all further steps are manual.
Call Application.Addons.ItemU("OrgCWiz").Run("/docopened")

The biggest pain point is when I get to setting up pages and levels of the org chart there are 25 pages to be created manually and as they almost never change I would prefer to pass it in the VBA code and never look back.

Is there a step by step code I can use to do the above? Please help...

[wapperdude]

This link might be of interest..https://blog.bvisual.net/2009/02/24/creating-an-org-chart-without-the-org-chart-wizard/.

Wapperdude

[igor_bnp]

  Thank you but that only gets me to a prompt....I need to go beyond that 

[wapperdude]

Odd, that should have worked.  Copy/paste.  Well, try this:
https://blog.bvisual.net/2009/02/24/creating-an-org-chart-without-the-org-chart-wizard/

Tested and works.

[igor_bnp]

Thank you