3 Replies Latest reply: Mar 24, 2015 9:31 AM by Olly Bond RSS

    Exporting Summaries to Excel with Formulas in Filenames

    Simon Knowd

      I have a large monarch extract that is working perfectly, but I need to export the summaries to individual files.  So far no issues, except when I come to the export of the summary.  When I select the split on key option it will only export to files named on the key without any extension, whereas I need to export them to a specified filename ie [keyfield value]_[start day of period]-[end day of period].[month].[year] and it must be in excel format so with a .xls or .xlsx extension so it will give me a file like [compnay name]_01-04.03.2015.xls

       

      Any ideas would be much appreciated

       

      Monarch Version 11.8