ASCII [.DAT, .TXT] Data File Export Automation Options

 

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 "