And i ONLY wrote in the edit code as follow
FileSystem.Rename(“C:\Ui\RPA\OUTPUT\Example_.xlsx”,“C:\Ui\RPA\OUTPUT\Example_DateTime.Now().ToStringyyyyMMddhhmm.xlsx”)
Where do i need to fix it and do i need to write something in the invoke code property ?
Thank you very much
eimon
Hi @eimon invoke code language is VBNet and in the edit code put
FileSystem.Rename(“C:\Ui\RPA\OUTPUT\Example_.xlsx”,“C:\Ui\RPA\OUTPUT\Example_" & Now.ToString("yyyyMMddhhmm”) & “.xlsx”)
Hello averjr
Thank you for the reply. But it still throws the exception.
Like this : Invoke code :Exception has been thrown by the target of invocation. do i need to make something in its property
Hello again @eimon, I am not sure but it is nice if you can check if the excel file you are trying to rename is not open as it looks like there is an excel application scope after your copy sheet which is using the new file. You can use “close workbook” or “close application” then add some delay then you can go with the invoke code to rename