Rename a Workbook

Hi All,

I’m writing a two different datatbles into a Workbbok. At each time, I want a to create a new workbook with timestamp or the same workbook need to be renamed using timestamp.

maybe something like:
“myexcel” + now.ToString + “.xlsx”

this might give you dots and other characters that are not accepted as file name, just replace them with nothing
now.ToString.Replace(“/”,“”).Replace(“:”,“”).Replace(" “,”")

Hi @Abishek,

Here is a shortcut to create the worksheet like bellow that I have attached it.

Sample (1.3 KB)

Note :
To rename the existing excel sheet you can use the below one without losing the data.