I am trying to create a excel file in shared folder with Excel application scope. file is getting created but is throwing exception:
• The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a currently open workbook
It is likely due to the lag time between the robot’s computer and the file server. It is creating a file in the robot, then moving onto accessing it before the file server has it properly saved.
In the first activity, use a Retry activity, then put your application scope within it and save the output as a workbook variable. Leave the condition of the retry activity blank so it will simply retry on error. Only do one or two actions within this application scope as you don’t want actual errors to occur in here.
In the second activity, just use the application scope without the retry activity and resume your normal processing.
Hi Dave,
I didn’t get exactly what should I try.
I am just creating a new file. I do not have any other activity to do. Just creat a new file and exit. That’s it
It worked.
Excel application scope creats .xlsx file in default. No need to give extension manually.
But somehow it got worked other than shared folder (not manually adding .xlsx to file name). But its not working in shared folder ( we have to add extension .xlsx) to make it work.
Dont know the reason but its working .