Differences in formulas using HTML between 97 and 2002
 

I have an import to excel feature in my ASP page where i
use HTML to build my excel worksheet. Putting formulas
(Example =Sum(A9:A34) OR =(D34+D37+D45)) in this worksheet
works perfectly in EXCEL 97. But does not work in EXCEL
2002.

Can anyone point out rule of thumb differences between the
2 versions for writing out formulas?

--Sample code for =Sum(A9:A34)

oExcel.Add "<TD NOWRAP ALIGN=right CLASS='report_red'
TITLE='" & FormatNumber(vFinal(iCols, iFinal), 5)
& "'<B" & "=SUM(" & sTempChar & Cstr
(iSection_MergeStart) & ":" & sTempChar & CStr
(iExcelNumLines-1) & ")" & "</TD"

--Sample code for =(D34+D37+D45)
oSegment1 is an Object variable
vSegmentTotalPos is an array which has 34,37,45 as elements

oSegment1.Add "<TD NOWRAP ALIGN=right CLASS='report_red'"
& "'<B=("

For iArr = 0 to UBound(vSegmentTotalPos)



If iArr < 0 Then

oSegment1.Add "+"

End If

oSegment1.Add "D" & CStr
(vSegmentTotalPos(iArr))

Next

oSegment1.Add ")</TD"

oExcel.Add oSegment1.value


thanks
sydney