Scheduled run pulling from excel documents

[paulsparrow]

I have an app scheduled to run every night that reads folders containing excel spreadsheets that are owned and updated by other team members.  The problem I have is if someone leaves one of the files open the job fails.

Is there a way to write something in the script to ignore open excel files?

Is there another approach I could take?

[m_woolf]

Set ErrorMode

[ahaahaaha · Accepted solution]

Hi Paui,

Look at here Error variables ‒ QlikView

My be a solution to set in a script

set ErrorMode=0;

Regards,

Andrey