Edit Module - Export to CSV - Commas in field value

[#1]

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?

[Gysbert_Wassenaar]

Specify a different separator, for example a semicolon: sObject.Export "C:\Test.csv", "; "

Or replace the comma's in the FullName field with something else.