Excel Save As using a variable

Can we use variables with the Excel Save As command? I attempted to call use a variable in the folder and filename fields but to no avail.

Thank you in advance! I hope this isn’t too basic of a question.

  • Matt

Hi Matt,
do you click Save As in an Excel file and then insert the filename from the variable?

Hi Alesia - I was able to resolve my question last night by simply trying to use a variable (entering ${variable_name} in the field) in the respective fields. Unlike like other actions, the Excel Open Spreadsheet and Save As actions do not show the list of available variables when I start typing a variable name so I made a poor assumption that I could not use a variable in the field. Turns out I can and it works perfectly. Thank you!

1 Like