In reference to this thread: https://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_27727445.html#a37999278
Now I tried to run my vbs script from SQL Job. Though I get Job executed successfully, it didn't open up my excel file. I went to view the history for this job and found
Executed as user: GSOPS4\SYSTEM. Microsoft (R) Windows Script Host Version 5.7 Copyright (C) Microsoft Corporation. All rights reserved.C:\WINDOWS\system
s(5, 1) Microsoft Excel: Microsoft Excel cannot access the file '\\gsops4\data_extracts\Te
07.xlsm'. There are several possible reasons: 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. Process Exit Code 0. The step succeeded.