Rename a Workbook


#1

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.


#2

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

edit:
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(" “,”")


#3

Hi @Abishek,

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

Sample :NewSheet.zip (1.3 KB)

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

Regards
Balamurugan.S