Single Quotes in "Microsoft Excel"

[Little_man]

Hi, I have a problem with “Microsoft Excel”;
How can I put a “Single Quote” in a cell?

Values:
Regel.i = 1 (temporary value).
ZipCode_City.s = “5223 ER |s-Hertogenbosch” (temporary value).

Replace “|” through “’” ( chr(124) replaced by chr(39) ).

Must be: “5223 ER ’s-Hertogenbosch”

Example:
ExcelObject\SetProperty("Cells( " + Str(Regel) + ", 11) = " + "'" + ReplaceString(ZipCode_City, "|", "'") + "'")

Any comments appreciated.

[Little_man]

Problem solved:

ExcelObject\SetProperty("Cells( " + Str(Regel) + ", 11) = " + "'" + ReplaceString(ZipCode_City, "|s", "$0027s") + "'")

Little_Man