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.