@lucabottacin @PJ_17 @BikashPanigrahi, I have found the solution to the excel error in discussion and I will try to be as precise as I possibly can.
In my scenario I am exporting a macro enabled excel workbook from SAP to local disk.
I Perfom formating operation on the locally saved workbook,
save the file with a new name
and read from the new file
and write it to another file
Solution in my scenario!!
what was I doing wrong?
I kept the excel activated SAP report Open within SAP whilst I tried to open the locally saved excel SAP report.
for some reason, Uipath does not like that I have not exited the SAP report, prior to opening the locally saved file.
So what I did was to add a few activities that exited the SAP report (I jut used a type into with the SAP short cut = “/n”)
And then after the SAP report had been exited I tried to allow the flow to open the Excel and voila it worked.
So the take here for all other developers experiencing the same error issue is to exit almost all excel like report related to the your workflow. Meaning the excel you are trying to open should be the only one on the screen. Probably other excel workbooks can be opened but should not be related to your current work.
Now, how did I figure it out?
I tested with Start process activity and and I told the Start process activity to continue on error, and i discovered that there were links in the locally saved filed from excel, trying to access the SAP excel file which stayed opened. So by exiting the SAP excel activated report the links were broken, and the locally saved file was able to open.