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

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

SwatiAgrawal — Wed, 09 Sep 2020 10:52:00 GMT

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
------------------------------

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

CristianHerrero — Wed, 09 Sep 2020 12:02:00 GMT

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
------------------------------

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

MiguelCarrillo — Wed, 09 Sep 2020 14:32:00 GMT

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

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

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