How to rename the excel sheet to current date using the Business Object: MS Excel VBO and action: "Save current workbook as"

[SwatiAgrawal]

I need to rename the excel sheet to current date. I am using the Business Object: MS Excel VBO and action: "Save current workbook as" I am unable to figure out how to do this. I have tried these two options. But looks like I am using wrong expressions. 

1. For Eg:    "C:\abc\def\xyz\&"FormatDate(Now(), "dd mm yyyy")".xlsx"

2. For Eg:    "C:\abc\def\xyz\&"MakeDate(Today())"&.xlsx"

Please help.

------------------------------
SWA
------------------------------

[CristianHerrero]

Hi Swati,

Please try 
"C:\abc\def\xyz\"&MakeDate(Today())&".xlsx"
"C:\abc\def\xyz\"&FormatDate(Now(), "dd mm yyyy")&".xlsx"

Kind regards

------------------------------
Cristian Lopez
RPA configurator
Volvo Cars
Europe/London
------------------------------

[MiguelCarrillo]

You can make it with this expressión inside a calc stage.

"C:\abc\def\xyz\"&FormatDate(Today(), "dd MM yyyy")&".xlsx"

------------------------------
Miguel Carrillo
------------------------------