Save the file in Excel Application scope with the current date and time

image
The bot will run everyday so first will save all the data in the file, I need to save the file with the data and time when the bot will be run…could anyone suggest that

Create a string variable, str = DateTime.Now.ToString(“ddMMyyyyhhmmtt”)

In the Excel Application Scope, give the file name as “MailData_” + str + “.xlsx”

3 Likes

Thanks a lot Karthik…

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.