Hello!

After Googling for weeks, I found this site on how to create an
organization chart using the data stored in an Access database:
http://www.codeproject.com/KB/database/BSRKOrganizationChart.aspx?fid=80985&df=90&mpp=25&noise=3&sort=Position&view=Quick&select=889341.

There are only 4 files (OrganizationCreate.asp, OrganizationOpen.asp,
dbOrganzationChart.mdb, and NewOrgChartLans.xlt).

The problem is that a) I don't have enough knowledge to read
through .asp code and b) the .asp files are set up for a server rather
than just for a local machine

Can someone look at this code and provide some help on what needs to
be changed so this can work on just my local computer to create the
chart?

Thanks!

VR/Lost

OrganizationCreate.asp:

<%@ Language=VBScript %>
<%response.buffer=true%>

<HTML>

<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<script language="javascript">
function fOpenChart()
{
document.OrgCreate.action ="OrganizationOpen.asp";
document.OrgCreate.submit();
}
</script>

<form name="OrgCreate" method=post>
<BODY  bgcolor=708090 >
<BR>
<BR>
<BR>
<BR>

<center>
<FONT color=00FFFF  size=5 style="FONT-STYLE:ARIAL FONT-SIZE:20px">
<I><B>Organization Chart</B></I>
</FONT>

<BR>
<BR>
<BR>

<input type=button id=OpenOrgChart name=OpenOrgChart value="Generate
Organization Chart" onclick="fOpenChart()">
</center>

<%
                dim strSQL,sconn,SQLConnect,SQLRecordSet
                Response.Buffer=true
                src=server.MapPath("dbOrganizationChart.mdb")
                sconn="provider=microsoft.jet.oledb.4.0;data source=" & src
                set SQLConnect=server.createobject("adodb.connection")
                SQLConnect.open sconn

%>

<%

Dim VDE,VDM,strSQLDGH,strSQLDDH,strSQLSH,strSQLDE,strSQLDM

VDE="DE"
VDM="DM"

        strSelDGH="DGH"

        'STARTING FROM TOP MANAGEMENT LEVEL
        'START AND END LEVEL CAN BE DECIDED BY THE USER

        strSQLDGH="select distinct(DGH) from tblOrganizationChart where
dgh='" & strSelDGH & "'"
        strSQLDDH="select distinct(DDH),DGH from tblOrganizationChart where
dgh='" & strSelDGH & "'"
        strSQLSH="select distinct(SH),DGH,DDH from tblOrganizationChart where
dgh='" & strSelDGH & "' order by DDH"

        strSQLDE="select * from tblOrganizationChart where ISODesignation='"
& VDE & "' and dgh='" & strSelDGH & "' order by DDH,SH,cadre,EmpID"
        strSQLDM="select * from tblOrganizationChart where ISODesignation='"
& VDM & "' and dgh='" & strSelDGH & "' order by DDH,SH,cadre,EmpID"

%>

<%
        Dim numOrderDGH
        numOrderDGH=0

        Dim ArrDGH()
        Dim ArrOrderDGH()
        Dim CntDGH
        CntDGH=0

                        Set 
SQLRecordSetDGH=Server.CreateObject("ADODB.RecordSet")
                        SQLRecordSetDGH.CursorType=adOpenStatic
                        SQLRecordSetDGH.Open strSQLDGH,SQLConnect

                        With SQLRecordSetDGH
                                Do while not .EOF
                                CntDGH=CntDGH+1
                                strDGH=trim(.Fields("DGH"))
                                numOrderDGH=numOrderDGH + 1
                                Redim Preserve ArrDGH(CntDGH)
                                Redim Preserve ArrOrderDGH(CntDGH)
                                ArrDGH(CntDGH)=strDGH
                                ArrOrderDGH(CntDGH)=numOrderDGH
                                .MoveNext
                                loop
                        End With

                        SQLRecordSetDGH.Close
                        Set SQLRecordSetDGH=Nothing


        Set SQLRecordSetDDH=Server.CreateObject("ADODB.RecordSet")
        SQLRecordSetDDH.CursorType=adOpenStatic
        SQLRecordSetDDH.Open strSQLDDH,SQLConnect

        Dim numOrderDDH
        numOrderDDH=0

        Dim ArrDDH()
        Dim ArrOrderDDH()
        Dim ArrDGHEndGrp()
        Dim CntDDH
        CntDDH=0

        With SQLRecordSetDDH
                Do while not .EOF
                CntDDH=CntDDH+1
                DDHDGH=trim(.Fields("DGH"))
                        For G=LBound(ArrDGH) to UBound(ArrDGH)
                                IF (trim(ArrDGH(G))=trim(DDHDGH)) then
                                Redim Preserve ArrDGHEndGrp(G)
                                        ArrDGHEndGrp(G)=CntDDH
                                End IF
                        Next
                strDDH=trim(.Fields("DDH"))
                numOrderDDH=numOrderDDH + 1
                Redim Preserve ArrDDH(CntDDH)
                Redim Preserve ArrOrderDDH(CntDDH)
                ArrDDH(CntDDH)=strDDH
                ArrOrderDDH(CntDDH)=numOrderDDH
                .MoveNext
                loop
        End With

        SQLRecordSetDDH.Close
        Set SQLRecordSetDDH=Nothing


        Set SQLRecordSetSH=Server.CreateObject("ADODB.RecordSet")

        SQLRecordSetSH.CursorType=adOpenStatic
        SQLRecordSetSH.Open strSQLSH,SQLConnect

        Dim numOrderSH
        numOrderSH=0

        Dim ArrSH()
        Dim ArrOrderSH()
        Dim ArrDDHEndGrp()
        Dim CntSH
        CntSH=0
        Dim strSHDataFlg
        strSHDataFlg="Failed"

        With SQLRecordSetSH
                Do while not .EOF
                CntSH=CntSH+1
                SHDDH=trim(.Fields("DDH"))
                        For G=LBound(ArrDDH) to UBound(ArrDDH)
                                IF (trim(ArrDDH(G))=trim(SHDDH)) then
                                Redim Preserve ArrDDHEndGrp(G)
                                        ArrDDHEndGrp(G)=CntSH
                                End IF
                        Next
                strSH=trim(.Fields("SH"))
                numOrderSH=numOrderSH + 1
                Redim Preserve ArrSH(CntSH)
                Redim Preserve ArrOrderSH(CntSH)
                ArrSH(CntSH)=strSH
                ArrOrderSH(CntSH)=numOrderSH
                strSHDataFlg="Success"
                .MoveNext
                loop
        End With

        SQLRecordSetSH.Close
        Set SQLRecordSetSH=Nothing


        Set SQLRecordSetDE=Server.CreateObject("ADODB.RecordSet")

        SQLRecordSetDE.CursorType=adOpenStatic
        SQLRecordSetDE.Open strSQLDE,SQLConnect

        Dim numOrderDE
        numOrderDE=0

        Dim ArrDE()
        Dim ArrOrderDE()
        Dim ArrDESHEndGrp()
        Dim CntDE
        CntDE=0
        Dim ArrDESHSuccess()
        Dim CntDESHSuccess
        CntDESHSuccess=0

        With SQLRecordSetDE
                Do while not .EOF
                CntDE=CntDE+1
                DESH=trim(.Fields("SH"))
                        For G=LBound(ArrSH) to UBound(ArrSH)
                                IF (trim(ArrSH(G))=trim(DESH)) then
                                Redim Preserve ArrDESHEndGrp(G)
                                        ArrDESHEndGrp(G)=CntDE
                                Redim Preserve ArrDESHSuccess(CntDESHSuccess)
                                ArrDESHSuccess(CntDESHSuccess)=G
                                CntDESHSuccess=CntDESHSuccess + 1
                                End IF
                        Next
                strDE=trim(.Fields("EmpID"))
                numOrderDE=numOrderDE + 1
                Redim Preserve ArrDE(CntDE)
                Redim Preserve ArrOrderDE(CntDE)
                ArrDE(CntDE)=strDE
                ArrOrderDE(CntDE)=numOrderDE
                .MoveNext
                loop
        End With

        SQLRecordSetDE.Close
        Set SQLRecordSetDE=Nothing



        Set SQLRecordSetDM=Server.CreateObject("ADODB.RecordSet")

        SQLRecordSetDM.CursorType=adOpenStatic
        SQLRecordSetDM.Open strSQLDM,SQLConnect

        Dim numOrderDM
        numOrderDM=0

        Dim ArrDM()
        Dim ArrOrderDM()
        Dim ArrDMSHEndGrp()
        Dim CntDM
        CntDM=0
        Dim ArrDMSHSuccess()
        Dim CntDMSHSuccess
        CntDMSHSuccess=0

        With SQLRecordSetDM
                Do while not .EOF
                CntDM=CntDM+1
                DMSH=trim(.Fields("SH"))
                        For G=LBound(ArrSH) to UBound(ArrSH)
                                IF (trim(ArrSH(G))=trim(DMSH)) then
                                Redim Preserve ArrDMSHEndGrp(G)
                                        ArrDMSHEndGrp(G)=CntDM
                                Redim Preserve ArrDMSHSuccess(CntDMSHSuccess)
                                        ArrDMSHSuccess(CntDMSHSuccess)=G
                                        CntDMSHSuccess=CntDMSHSuccess+1
                                End IF
                        Next

                strDM=trim(.Fields("EmpID"))
                numOrderDM=numOrderDM + 1
                Redim Preserve ArrDM(CntDM)
                Redim Preserve ArrOrderDM(CntDM)
                ArrDM(CntDM)=strDM
                ArrOrderDM(CntDM)=numOrderDM
                .MoveNext
                loop
        End With

        SQLRecordSetDM.Close
        Set SQLRecordSetDM=Nothing


%>


<%
Dim INPosition
Dim ArrSHPosition(),ArrDDHPosition(),ArrDGHPosition()
INPosition=1
%>

<%
Dim SHX
For T=1 to CntSH
        Redim Preserve ArrSHPosition(T)
        SHX=ArrOrderSH(T)
        ArrSHPosition(T)=(3 * (SHX))- 1
%>
<input type=hidden name=SrSHList id=SrSHList value="<%=ArrSH(T)%>">
<input type=hidden name=SrSHOrder id=SrSHOrder value="<%=ArrOrderSH(T)
%>">
<input type=hidden name=SrSHPosition id=SrSHPosition value="<
%=ArrSHPosition(T)%>">
<%
Next
%>

<%
For T=1 to CntDDH
        IF T=1 then
        %>
        <input type=hidden name=SrDDHStartPt id=SrDDHStartPt value="<
%=INPosition%>">
        <%
        Else
        %>
        <input type=hidden name=SrDDHStartPt id=SrDDHStartPt value="<
%=ArrDDHEndGRp(T-1)+1%>">
        <%
        End If

        Redim Preserve ArrDDHPosition(T)

        If T=1 then
        ArrDDHPosition(T)=(ArrSHPosition(INPosition)+ArrSHPosition
(ArrDDHEndGrp(T)))/2
        else
        ArrDDHPosition(T)=(ArrSHPosition(ArrDDHEndGrp(T-1)+1)+ArrSHPosition
(ArrDDHEndGrp(T)))/2
        end if

%>
<input type=hidden name=SrDDHList id=SrDDHList value="<%=ArrDDH(T)
%>">
<input type=hidden name=SrDDHOrder id=SrDDHOrder value="<%=ArrOrderDDH
(T)%>">
<input type=hidden name=SrDDHEndPt id=SrDDHEndPt value="<%=ArrDDHEndGrp
(T)%>">
<input type=hidden name=SrDDHPosition id=SrDDHPosition value="<
%=ArrDDHPosition(T)%>">
<%
Next
%>

<%
For T=1 to CntDGH
        IF T=1 then
        %>
        <input type=hidden name=SrDGHStartPt id=SrDGHStartPt value="<
%=INPosition%>">
        <%
        Else
        %>
        <input type=hidden name=SrDGHStartPt id=SrDGHStartPt value="<
%=ArrDGHEndGRp(T-1)+1%>">
        <%
        End If
        Redim Preserve ArrDGHPosition(T)
        ArrDGHPosition(T)=(ArrDDHPosition(ArrDGHEndGrp(T-1)+1)+ArrDDHPosition
(ArrDGHEndGrp(T)))/2
%>
<input type=hidden name=SrDGHList id=SrDGHList value="<%=ArrDGH(T)
%>">
<input type=hidden name=SrDGHOrder id=SrDGHOrder value="<%=ArrOrderDGH
(T)%>">
<input type=hidden name=SrDGHEndPt id=SrDGHEndPt value="<%=ArrDGHEndGrp
(T)%>">
<input type=hidden name=SrDGHPosition id=SrDGHPosition value="<
%=ArrDGHPosition(T)%>">
<%
Next
%>

<%
For T=1 to CntDE
Redim Preserve ArrDEPosition(T)
ArrDEPosition(T)=ArrOrderDE(T)
%>
<input type=hidden name=SrDEList id=SrDEList value="<%=ArrDE(T)%>">
<input type=hidden name=SrDEOrder id=SrDEOrder value="<%=ArrOrderDE(T)
%>">
<input type=hidden name=SrDEPosition id=SrDEPosition value="<
%=ArrDEPosition(T)%>">
<%
Next
%>

<%
For k=LBound(ArrDESHEndGrp) to UBound(ArrDESHEndGrp)
        IF k=LBound(ArrDESHEndGrp) then
%>
        <input type=hidden name=SrDEStartPt id=SrDEStartPt value="<
%=INPosition%>">
<%
        Else
%>
        <input type=hidden name=SrDEStartPt id=SrDEStartPt value="<
%=ArrDESHEndGrp(k-1)+1%>">
<%
        End if
%>
<input type=hidden name=SrDEEndPt id=SrDEEndPt value="<%=ArrDESHEndGrp
(k)%>">
<%
Next
%>

<%
For T=1 to CntDM
Redim Preserve ArrDMPosition(T)
ArrDMPosition(T)=ArrOrderDM(T)
%>
<input type=hidden name=SrDMList id=SrDMList value="<%=ArrDM(T)%>">
<input type=hidden name=SrDMOrder id=SrDMOrder value="<%=ArrOrderDM(T)
%>">
<input type=hidden name=SrDMPosition id=SrDMPosition value="<
%=ArrDMPosition(T)%>">
<%
Next
%>

<%
For k=LBound(ArrDMSHEndGrp) to UBound(ArrDMSHEndGrp)
        IF k=LBound(ArrDMSHEndGrp) then
%>
        <input type=hidden name=SrDMStartPt id=SrDMStartPt value="<
%=INPosition%>">
<%
        Else
%>
        <input type=hidden name=SrDMStartPt id=SrDMStartPt value="<
%=ArrDMSHEndGrp(k-1)+1%>">
<%
        End if
%>
<input type=hidden name=SrDMEndPt id=SrDMEndPt value="<%=ArrDMSHEndGrp
(k)%>">
<%
Next
%>

</BODY>
</Form>
</HTML>






OrganizationOpen.asp:

<%@ Language=VBScript %>
<%response.buffer=true%>
<HTML>

<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>

<%
CLDGHList=trim(Request.Form("SrDGHList"))
CLDGHOrder=trim(Request.Form("SrDGHOrder"))
CLDGHStartPt=trim(Request.Form("SrDGHStartPt"))
CLDGHEndPt=trim(Request.Form("SrDGHEndPt"))
CLDGHPosition=trim(Request.Form("SrDGHPosition"))
%>


<%
CLDDHList=trim(Request.Form("SrDDHList"))
CLDDHOrder=trim(Request.Form("SrDDHOrder"))
CLDDHStartPt=trim(Request.Form("SrDDHStartPt"))
CLDDHEndPt=trim(Request.Form("SrDDHEndPt"))
CLDDHPosition=trim(Request.Form("SrDDHPosition"))
%>

<%
CLSHList=trim(Request.Form("SrSHList"))
CLSHOrder=trim(Request.Form("SrSHOrder"))
CLSHPosition=trim(Request.Form("SrSHPosition"))
%>

<%
CLDEList=trim(Request.Form("SrDEList"))
CLDEPosition=trim(Request.Form("SrDEPosition"))
CLDEOrder=trim(Request.Form("SrDEOrder"))
CLDEStartPt=trim(Request.Form("SrDEStartPt"))
CLDEEndPt=trim(Request.Form("SrDEEndPt"))
%>


<%
CLDMList=trim(Request.Form("SrDMList"))
CLDMPosition=trim(Request.Form("SrDMPosition"))
CLDMOrder=trim(Request.Form("SrDMOrder"))
CLDMStartPt=trim(Request.Form("SrDMStartPt"))
CLDMEndPt=trim(Request.Form("SrDMEndPt"))
%>

<%
strExTemplatePath=Server.MapPath("OrgChartLans.xlt")
%>


<script language="vbscript">

Function OpenChart()

Dim strExcelPath
Dim strMaclevel

strExcelPath=trim(document.OpenOrgChart.ExFile.value)

'strExcelPath="HTTP:\\localhost\OrgChart\OrgChartLans.xlt"

Set xlApp =CreateObject("Excel.Application")
Set xlBook=xlApp.WorkBooks.Add(strExcelPath)
Set xlSheet=xlBook.WorkSheets("OrgChart")

Dim DDHRow,SHRow,DDHCol,DGHCol

DGHPS=2
DDHPS=3
SHPS=4

ValDGHList=document.OpenOrgChart.INDGHList.value
ValDGHStartPt=document.OpenOrgChart.INDGHStartPt.value
ValDGHEndPnt=document.OpenOrgChart.INDGHEndPt.value
ValDGHPosition=document.OpenOrgChart.INDGHPosition.value
ArrDGHStartPnt=Split(ValDGHStartPt,",")
ArrDGHEndPnt=Split(ValDGHEndPnt,",")
ArrDGHList=Split(ValDGHList,",")
ArrDGHPos=Split(ValDGHPosition,",")

RowESpace=0
DGHRow=(DGHPS-1)
DDHRow=(DDHPS-1)
SHRow=(SHPS-1)

Dim strDGH1
Dim ArrstrDGH1()
strDGH1=""

For i=LBound(ArrDGHList) to UBound(ArrDGHLIst)
        strDGH1=""
        DGHCol=cint(trim(ArrDGHPos(i)))
        strDGH1=trim(strDGH1) & trim(ArrDGHList(i))
        Redim Preserve ArrstrDGH1(i)
                IF not(len(strDGH1)=0)then
                ArrstrDGH1(i)=strDGH1
                else
                ArrstrDGH1(i)=0
                End if
Next
strMaclevel="DGH"
xlApp.Run "MacroDrawBox",UBound
(ArrDGHLIst),ArrstrDGH1,ArrDGHPos,DGHRow,strMaclevel

Dim strDDH1
Dim ArrstrDDH1()
strDDH1=""

ValDDHList=document.OpenOrgChart.INDDHList.value
ArrDDHList=Split(ValDDHList,",")
ValDDHPosition=document.OpenOrgChart.INDDHPosition.value
ArrDDHPos=Split(ValDDHPosition,",")

For i=LBound(ArrDDHList) to UBound(ArrDDHLIst)
        strDDH1=""
        DDHCol=cint(trim(ArrDDHPos(i)))
        strDDH1=strDDH1 & ArrDDHList(i)
        Redim Preserve ArrstrDDH1(i)
        ArrstrDDH1(i)=strDDH1
Next

strMaclevel="DDH"
xlApp.Run "MacroDrawBox",UBound
(ArrDDHLIst),ArrstrDDH1,ArrDDHPos,DDHRow,strMaclevel
strConLevel="DGH"
xlApp.Run "mConnectors",UBound
(ArrDGHLIst),ArrDGHStartPnt,ArrDGHEndPnt,strConLevel

Dim strSH1,MacEDRow
Dim ArrstrSH1(),ArrstrDE(),ArrstrDM(),ArrDECol(),ArrDMCol
(),ArrStartPtDE(), ArrEndPtDE()

strSH1=""
SHCol=0

ValSHList=document.OpenOrgChart.INSHList.value
ArrSHList=Split(ValSHList,",")

ValSHPosition=document.OpenOrgChart.INSHPosition.value
ArrSHPos=Split(ValSHPosition,",")

ValDEList=document.OpenOrgChart.INDEList.value
ValDMList=document.OpenOrgChart.INDMList.value
ArrDMList=Split(ValDMList,",")
ArrDEList=Split(ValDEList,",")

ValDMEndPt=document.OpenOrgChart.INDMEndPt.value
ValDEEndPt=document.OpenOrgChart.INDEEndPt.value
ArrDMEndPt=Split(ValDMEndPt,",")
ArrDEEndPt=Split(ValDEEndPt,",")


For i=LBound(ArrSHList) to UBound(ArrSHLIst)

        Dim SEmptyDE
        Dim SEmptyDM
        SEmptyDE=-1
        SEmptyDM=-1
        strSH1=""
        strSH2=""

                SHCol=cint(ArrSHPos(i))
                Redim Preserve ArrDECol(i)
                Redim Preserve ArrDMCol(i)
                ArrDECol(i)=SHCol-1
                ArrDMCol(i)=SHCol+1

                strSH1=trim(strSH1) & trim(ArrSHList(i))
                Redim Preserve ArrstrSH1(i)
                ArrstrSH1(i)=strSH1

                Dim strDE,strDM,strGroupDE,strGroupDM
                strGroupDE=""
                strGroupDM=""
                strDE=""
                strDM=""
                Redim Preserve ArrstrDE(i)
                Redim Preserve ArrstrDM(i)
                DMRow=SHRow
                DERow=SHRow
                MacEDRow = DMRow


                IF i=(LBound(ArrSHList)) then

                        For T=1 to ArrDEEndPt(i+1)
                                strDE=""
                                strDE=trim(strDE) & trim(ArrDEList(T-1))
                                strGroupDE=strGroupDE & "\" & strDE
                                DERow=DERow  + RowESpace
                        Next

                        Redim Preserve ArrStartPtDE(i)
                        Redim Preserve ArrEndPtDE(i)
                        ArrStartPtDE(i)=1
                        ArrEndPtDE(i)=ArrDEEndPt(i+1)
                        ArrstrDE(i)=strGroupDE


                        For T=1 to ArrDMEndPt(i+1)
                                strDM=""
                                strDM=trim(strDM) & trim(ArrDMList(T-1))
                                strGroupDM=strGroupDM & "\" & strDM
                                DMRow=DMRow + RowESpace
                        Next

                        Redim Preserve ArrStartPtDM(i)
                        Redim Preserve ArrEndPtDM(i)
                        ArrStartPtDM(i)=1
                        ArrEndPtDM(i)=ArrDMEndPt(i+1)
                        ArrstrDM(i)=strGroupDM

                ELSE


                        For T=(ArrDEEndPt(i)+1) to ArrDEEndPt(i+1)
                                strDE=""
                                strDE=trim(strDE) & trim(ArrDEList(T-1))
                                strGroupDE=strGroupDE & "\" & strDE
                                DERow=DERow  +  RowESpace
                        Next

                        Redim Preserve ArrStartPtDE(i)
                        Redim Preserve ArrEndPtDE(i)
                        ArrStartPtDE(i)=ArrDEEndPt(i)+1
                        ArrEndPtDE(i)=ArrDEEndPt(i+1)
                        ArrstrDE(i)=strGroupDE


                        For T=(ArrDMEndPt(i)+1) to ArrDMEndPt(i+1)
                        strDM=""
                        strDM=strDM & ArrDMList(T-1)
                        strGroupDM=strGroupDM & "\" & strDM
                        DMRow=DMRow + RowESpace
                        Next

                        Redim Preserve ArrStartPtDM(i)
                        Redim Preserve ArrEndPtDM(i)
                        ArrStartPtDM(i)=ArrDMEndPt(i)+1
                        ArrEndPtDM(i)=ArrDMEndPt(i+1)
                        ArrstrDM(i)=strGroupDM
                END IF
Next

ValDDHStartPnt=document.OpenOrgChart.INDDHStartPt.value
ValDDHEndPnt=document.OpenOrgChart.INDDHEndPt.value


Dim ArrDDHStartPnt,ArrDDHEndPnt
ArrDDHStartPnt=Split(ValDDHStartPnt,",")
ArrDDHEndPnt=Split(ValDDHEndPnt,",")


ECount=UBound(ArrSHLIst)
strMaclevel="SH"
xlApp.Run "MacroDrawBox",ECount,ArrstrSH1,ArrSHPos,SHRow,strMaclevel
strConLevel="DDH"
xlApp.Run "mConnectors",UBound
(ArrDDHLIst),ArrDDHStartPnt,ArrDDHEndPnt,strConLevel

xlApp.Run
"MacroDrawBoxED",ECount,ArrstrDE,ArrstrDM,MacEDRow,ArrDECol,ArrDMCol
xlApp.Run "mConnectorsED",ECount
xlApp.Run "mConnectorSubED",ECount,ArrStartPtDE, ArrEndPtDE,
ArrStartPtDM, ArrEndPtDM

xlApp.visible=true

Set xlApp=Nothing
Set xlBook=Nothing
Set xlSheet=Nothing

document.OpenOrgChart.action="OrganizationCreate.asp"
document.OpenOrgChart.submit()

End Function

</script>

<form name="OpenOrgChart" method="post">
<BODY onload="OpenChart()" BGCOLOR= 708090>

<input type=hidden name="INDGHList" id="INDGHList" value="<%=CLDGHList
%>">
<input type=hidden name="INDGHOrder" id="INDGHOrder" value="<
%=CLDGHOrder%>">
<input type=hidden name="INDGHStartPt" id="INDGHStartPt" value="<
%=CLDGHStartPt%>">
<input type=hidden name="INDGHEndPt" id="INDGHEndPt" value="<
%=CLDGHEndPt%>">
<input type=hidden name="INDGHPosition" id="INDGHPosition" value="<
%=CLDGHPosition%>">

<input type=hidden name="INDDHList" id="INDDHList" value="<%=CLDDHList
%>">
<input type=hidden name="INDDHOrder" id="INDDHOrder" value="<
%=CLDDHOrder%>">
<input type=hidden name="INDDHStartPt" id="INDDHStartPt" value="<
%=CLDDHStartPt%>">
<input type=hidden name="INDDHEndPt" id="INDDHEndPt" value="<
%=CLDDHEndPt%>">
<input type=hidden name="INDDHPosition" id="INDDHPosition" value="<
%=CLDDHPosition%>">

<input type=hidden name="INSHList" id="INSHList" value="<%=CLSHList
%>">
<input type=hidden name="INSHOrder" id="INSHOrder" value="<%=CLSHOrder
%>">
<input type=hidden name="INSHPosition" id="INSHPosition" value="<
%=CLSHPosition%>">

<input type=hidden name="INDMList" id="INDMList" value="<%=CLDMList
%>">
<input type=hidden name="INDMEndPt" id="INDMEndPt" value="<%=CLDMEndPt
%>">

<input type=hidden name="INDEList" id="INDEList" value="<%=CLDEList
%>">
<input type=hidden name="INDEEndPt" id="INDEEndPt" value="<%=CLDEEndPt
%>">
<input type=hidden name="ExFile" id="ExFile" value="<
%=strExTemplatePath%>">

</BODY>
</form>
</HTML>

Reply via email to