VBScript Runtime Error : Open method of Workbooks class failed

Question

When running VBScript, the Runtime Error appear

'Open method of Workbooks class failed'
Code : 800A03EC

the line in the vbscript where it stopped is
xlApp.Workbooks.Open(Replace(WScript.ScriptFullName, WScript.ScriptName, "") & "Testing Program.xlsm")

It happened randomly, e.g. once in a week and it did not happen every time run manually or under scheduler.

May I know if anyone can shed some lights on that ?

thanks !

Answer 1

Is that filename a local file?
If not, it can be that a mapped drive is (momentarily) not connected, or may even require a reboot before being connected again.
Use an error handler, and ask the user to check if the file exists and then click Retry.

Answer 2

the VBScript file is running locally under the desktop.