defining fields to be exported to excel

[hpw]

hi there!

i'm trying to create a script so that records can be exported to excel omitting unnecessary fields.

i thought to use the "export records" script step, define the fields i want to have exported then define the export format .xls but that doesn't seem to be possible. i can't define the export format without naming the resulting file.

as the db will be shared i can't name the result file as i can't define the path...but i only want to pre-define the format to make life of the users easier.

who can help me?

thanks

hans

[Roy Osborn]

use variables. Your export script will create a variable...say called $filePath. Then, in your export records dialog, specify the file as $filepath. Wamo, dynamically generated output file.

[hpw]

perfect! thanks a lot!