Hi,
Everytime when I exported a text field which is starting with "+" or "-" in Data Manager, I always got a vb run timer error 7. The vb debug mode told me that the excel "Template1" in "Module1" and in "Excel97InsertMacro" the below code like:
Application .ActiveSheet.Cells(row + startRow + 2, column + 1).value = myarr(row, column)
got exception. In order to get export file, the workaround solution has to manually put a ' sign before the myarr() like:
.... = "'" & myarr(row, column)
And then press F5 to continue, so the export file can be generated in this way.
Currently I have updated our MDM 5.5 SP06 with patch04 on version 5.5.64.84, but this problem is still existing. Can anybody tell me that any MDM updates can have this problem to be solved but not workaround solution ?
Thanks very much for your help
Kind regards,
Wei Dona