topic Scheduled run pulling from excel documents in QlikView https://community.qlik.com/t5/QlikView/Scheduled-run-pulling-from-excel-documents/m-p/1311077#M619219 <HTML><HEAD></HEAD><BODY><P>I have an app scheduled to run every night that reads folders containing excel spreadsheets that are owned and updated by other team members.&nbsp; The problem I have is if someone leaves one of the files open the job fails.</P><P></P><P>Is there a way to write something in the script to ignore open excel files?</P><P></P><P>Is there another approach I could take?</P></BODY></HTML> Thu, 30 Mar 2017 14:48:49 GMT paulsparrow 2017-03-30T14:48:49Z Scheduled run pulling from excel documents https://community.qlik.com/t5/QlikView/Scheduled-run-pulling-from-excel-documents/m-p/1311077#M619219 <HTML><HEAD></HEAD><BODY><P>I have an app scheduled to run every night that reads folders containing excel spreadsheets that are owned and updated by other team members.&nbsp; The problem I have is if someone leaves one of the files open the job fails.</P><P></P><P>Is there a way to write something in the script to ignore open excel files?</P><P></P><P>Is there another approach I could take?</P></BODY></HTML> Thu, 30 Mar 2017 14:48:49 GMT https://community.qlik.com/t5/QlikView/Scheduled-run-pulling-from-excel-documents/m-p/1311077#M619219 paulsparrow 2017-03-30T14:48:49Z Re: Scheduled run pulling from excel documents https://community.qlik.com/t5/QlikView/Scheduled-run-pulling-from-excel-documents/m-p/1311078#M619220 <HTML><HEAD></HEAD><BODY><P>Set ErrorMode</P></BODY></HTML> Thu, 30 Mar 2017 14:52:08 GMT https://community.qlik.com/t5/QlikView/Scheduled-run-pulling-from-excel-documents/m-p/1311078#M619220 m_woolf 2017-03-30T14:52:08Z Re: Scheduled run pulling from excel documents https://community.qlik.com/t5/QlikView/Scheduled-run-pulling-from-excel-documents/m-p/1311079#M619221 <HTML><HEAD></HEAD><BODY><P>Hi Paui,</P><P></P><P>Look at here <A href="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ErrorVariables/ErrorVariables.htm" title="http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ErrorVariables/ErrorVariables.htm">Error variables ‒ QlikView</A></P><P></P><P>My be a solution to set in a script</P><P></P><P>set ErrorMode=0;</P><P></P><P>Regards,</P><P>Andrey</P></BODY></HTML> Thu, 30 Mar 2017 14:58:55 GMT https://community.qlik.com/t5/QlikView/Scheduled-run-pulling-from-excel-documents/m-p/1311079#M619221 ahaahaaha 2017-03-30T14:58:55Z