We had a guy who worked for us who wrote some export scripts from FileMaker 11 into .xls using the following:
If(Get(AccountName) = "XXX"; "save workbook as active workbook filename \"TB:AP:P:PI:BD:BUY_"&$id&".xls\" file format Excel98to2004 file format";"save workbook as active workbook filename \"TB:AP:P:PI:BD:BUY_"&$id&".xls\"")
&¶&"close active workbook"&¶&"
We've since upgraded to Office 2011 and Lion, however, Lion doesn't have Rosetta needed to export as .xls. I need to modify this export so it comes out in .xlsx. I'm sure it has something to do with the "file format Excel98to2004 file format" piece of this script, but I'm not sure what to sub in its place.
Need AppleScript help in Lion w/ FMP