VBA in task scheduler closes other opened excel tabs after the execution

[Manikanta9333]

Hello,

I have implemented a macro in vba that refreshes the data from a database and scheduled it using the windows task scheduler. I have attached the vbs code for reference:

>>> use code - tags <<<

ExcelFilePath = "C:\Users\hp\Desktop\TEST\test.xlsm"  ' File path
MacroPath = "test"  ' Macro name
Set ExcelApp = CreateObject("Excel.Application")
ExcelApp.Visible = True 'or "False"
Set wb = ExcelApp.Workbooks.Open(ExcelFilePath)
ExcelApp.Run MacroPath
wb.Save
wb.Close
ExcelApp.Quit

Windows task scheduler closes other opened excel tabs after the macro execution. I tried executing on other systems also. Sometimes it's working (doesn't close all excels) sometimes it doesn't.

Please help me resolve this issue.

 

[Marc L]

As this is a wild cross posting you must read the forums rules and do the necessary :​

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org