0 Replies Latest reply on Jan 30, 2012 11:30 AM by glimmieglimbo

    DDE export MS Word limited 255 characters

    glimmieglimbo

      Hello FileMaker-lovers,

       

      I work with EZxslt to generate XSL-files which FM use to generate MS-Word reports. This works perfect. The Word-docs are rather large due to several pictures (company logo etc.) in the original document (4 mb) and the fact that the docs are first save in rtf-format.

      Now the company wants to work in the cloud and the bandwith is the bottleneck here. So in order to increase the datatraffic I want to call the Word-doc and replace the fields with the data from filemaker with a DDE call.

      This works perfect but I have one problem and that is the limitation of 255 characters export to Word.

      for example:

       

      WordBasic.EditReplace Find:="<<VersSomHuur>>", Replace:="Huurdersbelang" + Chr(9) + ": €." + Chr(9) + "2.000.000,--" + Chr(13) + "Inventaris" + Chr(9) + ": €." + Chr(9) + "3.000.000,--" + Chr(13) + "Goederen" + Chr(9) + ": €." + Chr(9) + "4.000.000,--" + Chr(13) + "Bedrijfsschade" + Chr(9) + ": €." + Chr(9) + "5.000.000,--" + Chr(13) + "Extra kosten" + Chr(9) + ": €." + Chr(9) + "6.000.000,--" + Chr(13) + "Reconstructie" + Chr(9) + ": €." + Chr(9) + "7.000.000,--" + Chr(13) + "Opruimkosten" + Chr(9) + ": €." + Chr(9) + "8.000.000,--" + Chr(13) + "Elektronika" + Chr(9) + ": €." + Chr(9) + "9.000.000,--" + Chr(13) + "Machinebr" + "euk" + Chr(9) + ": €." + Chr(9) + "10.000.000,--" + Chr(13) + "Machinebreuk/Bedrijfsschade" + Chr(9) + ": €." + Chr(9) + "11.000.000,--" + Chr(13) + "Bedrijfsaansprakelijkheid " + Chr(9) + ": €." + Chr(9) + "12.000.000,--" + Chr(13) + "Goederen elders " + Chr(9) + ": €." + Chr(9) + "13.000.000,--", ReplaceAll:=1, Wrap:=1

       

      Does anyone knows a workaround for this limitation or is there another way to generate the MS-Word documents with the data from filemaker.... with sometimes large amount of data for one field.

       

      Thanks for the information.

       

      Greetings,

      Martin van Wijnen

      The Netherlands.