Question
BACI
IN
Last activity: 13 Jun 2018 20:47 EDT
How to close a file that opened during automation
Hi,
Need your help.
I have a requirement to automate a flow and in the process I need to close documents that opened during the flow. I cannot proceed without closing opened documents. Could you let me know how that be achieved in openspan.
Appreciate your help.
Thanks,
Srikanth.
Pegasystems Inc.
IN
Are you referring to Excel? If yes, have you tried with close method?
BACI
IN
No, I don't mean excel file. we have to process x.doc, y.xls , or x.*(few file extensios) and the application we are going to automate open these files. I want to know if we can call some script or method from openspan to close these opened files. ( just to clear : These are files are open by application and not by openspan).
Appreciate your help.
Thanks,
Srikanth.
Westpac Banking Corporation
AU
All MS office files have close method. so you can use this method in the automation flow.
Note: If you terminate automation then it will close automatically all applications / documents used in the automation.
Coming to your point: If openspan is not opening applications still you can close those docs by using office connectors and passing file name, I didn't try. OR
Use script and check if any file instances are created then you can close them.
https://docs.microsoft.com/en-us/visualstudio/vsto/how-to-programmatically-close-documents