How to 'delete Excel sheet', 'Rename excel file with today function' and 'Copy and Paste the existing excel file' using Studio?

-‘Delete Excel sheet’, :- You can use macro to delete Sheet.
-‘Rename excel file with today function’ and :- Use Move File activity and in destination use Todays date in file name. (Date.Now.Tostring(“MMddyyyy”))
-‘Copy and Paste the existing excel file’ :- Use copy file activity.

Macro:-

Sub Delete_Sheet_WithoutWarningMessage()
Application.DisplayAlerts = False
Sheets(“Sheet2”).Delete
Application.DisplayAlerts = True
End Sub

Reference to use Macro in UiPath using Invoke VBA

Regards,
Prathamesh

1 Like