• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 864
  • Last Modified:

Visio Organization Chart from Access

I have an Access DB. I would like to be able to generate a Visio Organization Chart from my Access project with the press of a button. Anyone know the code that I would need to run in Access?

1 Solution
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperCommented:
As you may know, Visio's organization chart wizard can read data from an Access database to create a chart. To view the necessary visio code to accomplish this, I would suggest startiing in Visio: turn on the macro recorder then launch the org chart wizard. Complete the wizard then ALT+F11 to view the macro code.

If you want to run this code from Access, you can set a reference to Visio in your Access project and should be able to adapt the Visio code to run in that environment.

If you need more specifics on the Visio side, just let me know.

Hi VoodooFrog,

In Visio 2007 the command is Tools - Add-Ons -Visio Extras -Database Wizard.
Have a look at http://office.microsoft.com/training/training.aspx?AssetID=RC101977211033

Good Luck!


Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now