1 Reply Latest reply: Jun 13, 2013 7:39 AM by Gysbert Wassenaar RSS

    Edit Module - Export to CSV - Commas in field value

      Hi everyone,


      I have a macro:


      Sub ExportToCSV


      set sObject = ActiveDocument.GetSheetObject("TB01")

      sObject.Export "C:\Test.csv", ", "


      End Sub



      However, I have a field FullName, which has values of the format LastName, FirstName.


      When I run this macro, LastName and FirstName incorrectly get split into two columns because of the comma.  Is there any way to qualify these cell values so it stays in 1 cell, somehow?