export records not working with file extension

[fatherb]

Hi all,

Please help! I'm going la la here trying to sort out how to export or save records as an excel file (neither way works).

I have created a script that should automatically find a bunch of records, and then export specific fields into an Excel spreadsheet that i can email out. Using 'Set Variable' commands it saves the resulting file to the desktop with the name of a field in the database. That way I can loop through the database and create different filenames for each record.

Works brillantly - except for one thing! The 'save as excel' and the 'export records' script step both fail to put on the file extension for Excel, namely .xls. The people at the other end receiving this automatic email aren't that clever and I can't rely on them being able to rename the file to xxx.xls.

I've tried adding & ".xls" to set variable script and tried making a new filename variable that sets the name to xxx & ".xls" but both methods produce errors. I've attached a pdf of the script as whole solution far too big to post.

Can anyone help?

thanks heaps

dave

export_script.pdf

[fatherb]

thanks to those that looked but i figured it out in the end.

I added additional words to the set variable by using set variable[$filepath; Value:Get (DesktopPath ) & fieldname & "_morewords.xls"

interestingly it would not work if I just tried adding ".xls" to the end.

just thought I would share with you all.