Help

FILEMAKER PRO HELP 1057
If [not PatternCount ( Get ( DocumentsPathListing ); "Unpaid Invoice
List.xlsx" )]
Export Records [No dialog; "Unpaid Invoice List.xlsx"; Unicode (UTF-
16)]
End If
Related topics
Import Records script step
Save Records As PDF script step
Save Records As Excel script step
Script steps reference (alphabetical list)
Script steps reference (category list)
Save Records As Excel
Purpose
Saves records to a specified Excel worksheet.
Format
Save Records As Excel [Restore; No dialog; “<output filename>”;
Automatically open; Create email; Records being browsed/Current record]
Note In order to save records as a Microsoft Excel worksheet, your privilege set must include Allow
exporting, or you must select Run script with full access privileges in the Edit Script dialog box.
Options
• Perform without dialog prevents the Excel Options dialog box from displaying as the script
step executes if you have already specified a file. If you have not specified a file, the Save
Records as Excel dialog box displays as the script step executes, but the Excel Options
dialog box is not displayed.
• Select Specify output file or click Specify to display a dialog box where you can specify
the file path. Choose the folder you want to export to, or type the file path directly into the
list. Specify one path per line. FileMaker
Pro will use the first path it locates. See Creating
file paths. You can choose to Automatically open file or choose to Create email with file
as attachment to create a blank email with the Excel file as an attachment.
If FileMaker Pro executes a script that does not specify an absolute path, and the database file
containing the script is hosted, the path is assumed to be the current user’s Documents folder.
• Select Specify options or click Specify to display the "Save Records as Excel" Options
dialog box. From the Save list, choose Records being browsed or Current record.
Specify whether the values in the first row should be used as field names or as data. For
Worksheet, Title, Subject, and Author, you can enter text directly, or click Specify to enter
a field name or values from a calculation.
Compatibility
Where the script step runs Supported
FileMaker Pro Yes