3 Replies Latest reply on Feb 13, 2017 5:47 PM by ronanjcullen

    exporting to excel

    ronanjcullen

      Friends,

      I have written a short script whose purpose is to perform a find, and export the found records to an Excel spreadsheet. I'm facing a problem with teh output file, however. It does not seem to be in Excel format, and I can't seem to open it. At the same time, when I stepped through the commands, I was able to correctly output the file and open it in Excel. Can anyone suggest what I may be missing?

       

      Here is the script I have:

      Go to Latout ["RenewalsTable" (RenewalsTable)]

      Perform Find [Restore]

      Export Records [No Dialog; "UpcomingRenewals"; Automatically open; Western European]

      Go to Layout [original layout]

       

      I am using Filemaker Pro 13.

       

      Thanks in advance. Ronan Cullen