Since the Export Options dialog is not displayed when the program is driven from an automation script, an options string can be specified in the script. The string consists of comma-separated parameters, which specify the behavior of the various import options. A typical example would be:
" Delimiter=comma,tab; TextQualifier=singlequote"
This would export the worksheet using commas and tabs as the column delimiter, and the single quote mark as the text qualifier.
Option |
Action |
Default |
Delimiter |
Comma-separated list of named delimiter characters. Valid names are: “comma” “space” “tab” "semicolon" |
“comma,tab” |
TextQualifier |
Comma-separated list of named text-qualifying characters. Valid names are: “singlequote” “doublequote” “none” |
"none" |
DecimalSymbol |
This is available only with .TXT files. Valid names are: "comma" "period" |
set by Tools | Options |
Remarks
When specifying a delimiter and text-qualifier a semicolon is placed between the option pair, i.e.
"Delimiter=semicolon,; TextQualifier=singlequote "