Microsoft Excel Export Automation Options

 

Since the Excel 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 export options. A typical example would be:

 

"FileFormat=biff5"

 

This would set the file format to BIFF5 (i.e., Excel 95).

 

Option

Action

Default

FileFormat

Determines the file format. Valid values: biff8 (Excel 97) biff5 (Excel 95)

biff8

 

 

See Also

Excel XLS Files