[Manifold-l] Simple VB Help
lkong at engenious.com
lkong at engenious.com
Thu Oct 12 21:37:54 CDT 2006
I'm a c# programmer trying to write a simple VB Script. I'm sure it is a
syntax issue, but I sure can't see it. When I try to run this, I get a
Division by Zero, line 23 message. Line 23 is the Xval = line.
I would appreciate any hints that I can get on this one.
Sub Main
Set CSet=Application.ActiveDocument.ComponentSet
Set WDraw=CSet.Item("Runoff pattern 2")
Set WTbl=WDraw.OwnedTable
Set WColSet=WTbl.ColumnSet
rem assume columns are defined
Set rs=wTbl.Selection
runNum = 1
seq=1
fromcnt=0
tocnt=0
rs.Item(0).Data("seq") = seq
seq=seq+1
Xval=0.0
Yval=0.0
LLen=0.0
for n=1 to rs.Count-1 step 1
rs.Item(n-1).Data("To")=rs.Item(n).Data("ID")
rs.Item(n).Data("From")=rs.Item(n-1).Data("ID")
rs.Item(n).Data("Run") = runNum
rs.Item(n).Data("Seq") = seq
seq=seq+1
Xval = (rs.Item(n-1).Data("X (I)") - rs.Item(n).Data("X (I)"))^2
Yval = (rs.Item(n-1).Data("Y (I)") - rs.Item(n).Data("Y (I)"))^2
LLen=Sqr(Xval+Yval)
rs.Item(n-1).Data("LineToLen")=LLen
Z=rs.Item(n-1).Data("Height")-rs.Item(n).Data("Height")
if Length>0.0 then
rem rs.Item(n-1).Data("LineToSlope")=Z/LLen
end if
next
rs.Item(rs.Count-1).Data("LineToLen")=0.0
End Sub
Thank You
Lenny
More information about the Manifold-l
mailing list