I use a script to compile the previous weekly report info. Is there a way to make it change the excel file name when it exports so that my data in excel isn't lost? Ideally i want a separate excel file for each week.

Hi there,

Have you tried construction a variable and using that as the filename? This way your filename can be unique for each week

James

www.soliantconsulting.com/apps/filemaker/

im not experienced in variables. Would $vargetdate work as the title?

I would prefer the first date in the search to be use for the file name but haven't the slightest clue where to start.