Export Collection to Excel dialog box

Use the Export Collection to Excel dialog box to export the current collection to a comma separated file. Once you specify the folder where the file is to be saved, you are prompted whether to open the file in Microsoft Excel. Each record in the collection becomes a row in the exported file. Each field (property) becomes a column in the exported file.

This table lists the elements in this dialog box and explains their use.

Element Function/Comments
Browse

The text box for the path is set to the default path when this dialog appears. The default path is the last folder that was selected in a previous export operation.

If no path is specified when you attempt to save the file, this dialog prompts you to specify the destination folder. Click this button to locate the folder where the file is to be saved.

Note: The system saves the file in the My Documents folder by default. If you have previously selected a folder, that folder is used as the default.
Match sequence of columns in the related grid. If the spreadsheet columns should match the order of the grid columns on the form, select this option (which is selected by default).

If the spreadsheet columns should match the order of the property list in the form's IDO, clear this option.

To access this dialog box, select To Excel from the Actions menu, or click the "Export data to Excel" button on the toolbar.