Save Excel Sheet with Today's Date

[jokano1 (Jason Okano)]

I have a Workflow that will run each day and create an excel spreadsheet. Is there a way to save the new excel sheet under that day’s date. IE. If today was 06/05/2022 when the flow was run it would save the excel sheet as “Excel Name - 06/05/2022”?

[Yoichi]

Hi,

Unfortunately, sheet name of Excel is not allowed to use “/” character. So we need to compromise it as “06052022” for example.

If we use WriteRange activity as the following and there is no sheet which has the name, the sheet will be created.

Now.ToString("MMddyyyy")

Regards,

[jokano1 (Jason Okano)]

Awesome thanks. Is there a way to do this for the whole excel workbook?

[Yoichi]

Hi,

@jokano1

Is there a way to do this for the whole excel workbook?

Do you mean filename?
Can you share expected output for understand your requirement clearly?

Regards,

[avejr748 (Ave Salvante Jr)]

Yes, same as the answer of @Yoichi, but instead of “test.xlsx” replace it with

"Excel Name - " & Now.ToString(“mmddyyyy”)

Also as @Yoichi mentioned, the “/” date separator would not be allowed in filenames so you can also try other separator such as “-”

[jokano1 (Jason Okano)]

@avejr748

"Excel Name - " & Now.ToString(“mmddyyyy”)

what would the format be using that formula with the .xlsx at the end? I keep getting either “End of expression expected” or if i dont add the .xlsx it says expects format .xlsx

[Yoichi]

Hi,

Can you try as the following?

"PrefixString"+Now.ToString("MMddyyyy")+".xlsx"

Regards,

[jokano1 (Jason Okano)]

Its working now. Thanks!

[Veera_Raj (Veeraraj Sethuraman)]

var1=now.tostring(“dd-MM-yyyy”)
“Filename-”+var1.replace(“-”,“/”)+“.xlsx”