FM8. I have added a button to a layout to Export records as Excel. The
Specify options allow me to select the fields to export and also to name
the worksheet within the spreadsheet from a field value.
However, there does not seem to be a way to automatically generate a
unique name of the spreadsheet file based on a field value. Can this be
done with a script?
Michael Paine

Michael Paine wrote:
In FM8, you should be able to set a variable to the file path for the
..xls, then enter that variable name in your Export script step.

So you might set a variable ($ExportPath) to:
"file:" & get(desktoppath) & "/" & "Data_as_of_" &
dayname(get(currentdate)) & ".xls"

And then in your export script step, set the destination as $ExportPath


--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California

FileMaker 7 Certified Developer
Associate Member, FileMaker Solutions Alliance

Worked perfectly, thanks Howard

Michael Paine

-------
Set Error Capture [ On ]
Set Variable [ $$FILE_NAME; Value:"fileATA/" & VARIANT::model_id &
".XLS" ]
Export Records [ File Name: “$$FILE_NAME”; Use field names as column
names; Worksheet: VARIANT::model_id ]
[ No dialog ]
--------------------

Howard Schlossberg wrote: