Skip to Content
0
Former Member
Apr 09, 2009 at 03:09 PM

Run-time error:7 when export to excel in MDM Data Manager

118 Views

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