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:

 

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.

Outcomes