Creating a Dynamic Organization Chart

[Jeff Tolman]

Hello!

I'm looking for some guidance in how to create a dynamic organization chart.
The solution needs to be data-driven since my data resides in a MSSQL data
table. I've been able to create an org chart based on data from the table
by using the Organization Chart Wizard. I'd like to find a way around doing
that, perhaps a VBA Automation solution? It would be nice to just run an
executable app that generates the org chart (preferrably in HTML for a web
page). I also will need to be able to create the chart so that it is broken
up properly between pages.

Any suggestions or even better some places to start looking? Has anyone
done this before? Also please let me know if you have any questions.

Thanks in advance!

Jeff Tolman
E&M Electric

 

[JuneTheSecond]

Somebody said in this forum that ADO would be strong tool to access database
from Visio or other Office applications.
An example is,,

Private Sub Btn1_Click()
　　　 Dim cn 　As ADODB.Connection
Dim rs As New ADODB.Recordset

Set cn = CurrentProject.Connection

rs.Open "ProdTable",cn,adOpenKeyset,adLockOptimistic,adCmdTableDirect

rs.AddNew

rs("ProdName") = Me![ProdBame]
rs("ProdPrice") = Me![ProdPrice]

rs.Update

rs.Close
Set rs = Nothing
　　　　cn.Close
Set cn = Nothing

End Sub

But if you are going to build web services, next might be a good reference.
"Connecting to Online Data Using Visio 2003" in mbsd.
http://msdn.microsoft.com/library/d...3_ta/html/OfficeVisio2003DataConnectivity.asp