if\else hepl

[rjhe22]

i have this bit of code

If CDbl(sAmount) < 0 Then
            If CDbl(sAmount) < 0 Then ' (MTRBC_ARRAY$(MTRBC_CCYAMOUNT)
                SNEX_ARRAY$(EXE_CD) = "D"
            Else
                SNEX_ARRAY$(EXE_CD) = "C"
            End If
                   sOut = ""
                  For j = 2 To UBound(SNEX_ARRAY$)
                      sOut = sOut & SNEX_ARRAY$(j)
                   
                   Next j
              Call WritetoSNEXFile(sOut)

what i need to do is if the amount is =0 then not to write it out to the file and if its not then do what i have there

[DataMiser]

Something like this ?

If Not CDbl(sAmount) = 0 Then
            If CDbl(sAmount) < 0 Then ' (MTRBC_ARRAY$(MTRBC_CCYAMOUNT)
                SNEX_ARRAY$(EXE_CD) = "D"
            Else
                SNEX_ARRAY$(EXE_CD) = "C"
            End If
                   sOut = ""
                  For j = 2 To UBound(SNEX_ARRAY$)
                      sOut = sOut & SNEX_ARRAY$(j)
                   
                   Next j
              Call WritetoSNEXFile(sOut)
End If