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... :-[
This link might be of interest..https://blog.bvisual.net/2009/02/24/creating-an-org-chart-without-the-org-chart-wizard/.
Wapperdude
:-[ Thank you but that only gets me to a prompt....I need to go beyond that 8)
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/ (https://blog.bvisual.net/2009/02/24/creating-an-org-chart-without-the-org-chart-wizard/)
Tested and works.
Thank you