5 Replies Latest reply on Mar 8, 2016 9:59 AM by mjbenun

    Help with Save as Excel Script Step

    mjbenun

      I have a script that saves a found set of records as an Excel file on my desktop.  I would like to name this file based on a simple calculation (e.g.  Field1&Field2).  I have set a variable called $filename to the value of the calculation and set up the output path as follows:

       

      file:../../Desktop/$filename.xlsx

       

      When I run the script I end up with an excel file on my desktop named $filename.xlsx!  When I remove the .xlsx (file:../../Desktop/$filename), I do get a file named Field1&Field2, however, it is not recognized as an Excel file.

       

      Please advise what I am doing wrong..?

       

      Thank you in advance.