Hi @sksk
Try as below
Copy paste the below steps to your PAD and change the path of the file
DateTime.GetCurrentDateTime.Local DateTimeFormat: DateTime.DateTimeFormat.DateOnly CurrentDateTime=> CurrentDateTime
Excel.LaunchExcel.LaunchAndOpenUnderExistingProcess Path: $'''C:\\Users\\Srini\\OneDrive - 3s6yhv\\Documents\\Assessment_Renwals.xlsx''' Visible: True ReadOnly: False Instance=> ExcelInstance
Excel.SetActiveWorksheet.ActivateWorksheetByName Instance: ExcelInstance Name: $'''Sheet1'''
Excel.CopyCellsFromExcel.CopyAllCells Instance: ExcelInstance
SET SheetName TO $'''%CurrentDateTime.Day%-%CurrentDateTime.Month%'''
Excel.AddWorksheet Instance: ExcelInstance Name: SheetName WorksheetPosition: Excel.WorksheetPosition.Last
Excel.PasteCellsToExcel.PasteAt Instance: ExcelInstance Column: 1 Row: 1
Excel.CloseExcel.CloseAndSave Instance: ExcelInstance
If you find this reply helpful, please consider giving it a LIKE AND
If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION
Thanks,
Srini
