/ Forums / Advansys Formativ / Creating Solutions with Formativ / publish to excel? / Reply To: publish to excel?

July 29, 2004 at 8:52 pm #6480
Support 1
Participant

    There are probably several ways you can do this. Here are two:

    • Set the Excel cell wraptext to accept hard returns:

      ActiveSheet.Cells(0, 1).WrapText = True

    • Before exporting to Excel, remove hard returns:

      iValue = Replace(iValue, vbCrLf, ” “)

    I hope this helps you.

    Advansys Support