Script to find criterion, save to excel ... rinse lather repeat :)

[lcouri]

I am assembling a script to find a criterion, export the results to excel ... I've done this but I have 50+ criterion to search and save out to excel.  Is there a simple way of doing this?  I'm having to cut and paste, change the criterion and output file name  etc.  

 

Thanks!

 

Lance

[bcooney]

Need a lot more info to let you know if this can be scripted. Why not output everything and filter in Excel?

[lcouri]

Thanks, I've been doing that but I wasn't sure if working with the two programs is the most streamlined approach or if developing FMP scripts was the way to go.

L.

[bcooney]

You could investigate using FM as an ODBC source to Excel. Again, not enough info to understand why Excel is used at all.