AnsweredAssumed Answered

Help with Save as Excel Script Step

Question asked by mjbenun on Mar 8, 2016
Latest reply on Mar 8, 2016 by 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:




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.