I’m not allowed to use 3rd party coding package.
Only I can use the basic activities in Studio.
But I cannot find activities to realize below functions:
-‘Delete Excel sheet’,
-‘Rename excel file with today function’ and
-‘Copy and Paste the existing excel file’
Could anyone have coding for these functions? thanks!
-‘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.
Application.DisplayAlerts = False
Application.DisplayAlerts = True
Reference to use Macro in UiPATH using Invoke VBA
[quote=“Rita_Guan, post:1, topic:354535”]
Delete Excel sheet’,[/quote]
Now.ToString(“MMddyyyy”) or whatever format you want. Use Move File to rename it.
Don’t copy/paste. Move File.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.