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

    Edit Module - Export to CSV - Commas in field value

    David Koschei

      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?