Maggi Soffa

<div>
It has Set objExcel = CreateObject(&quot;Excel.Applic<wbr />ation&quot;) <br />
There are no errors just stops but I can see in the Task Manager it opens Excel.
</div>


It has Set objExcel = CreateObject("Excel.Application")
There are no errors just stops but I can see in the Task Manager it opens Excel.

<div>
Try to use the Microsoft Sysinternals Process monitor tool to find out what events were failed.
</div>


Try to use the Microsoft Sysinternals Process monitor tool to find out what events were failed.

<div>
IIRC Excel (as all Office) tasks require a GUI session, and if running &quot;whether logged on ...&quot; there is no such session.<br />
Maybe you can restrict the task to work with a CSV file instead, which does not require Office Automation.
</div>


IIRC Excel (as all Office) tasks require a GUI session, and if running "whether logged on ..." there is no such session.
Maybe you can restrict the task to work with a CSV file instead, which does not require Office Automation.

<div>
I need &nbsp;Excel to make the CSV/TEXT file automaticly therefrom another program process it.
</div>


I need  Excel to make the CSV/TEXT file automaticly therefrom another program process it.

<div>
<blockquote>
Excel (as all Office) tasks require a GUI session
</blockquote>
Not exactly. Please see my first comment which contains an instruction how to make the Excel work without a GUI session.
</div>


> Excel (as all Office) tasks require a GUI session

Not exactly. Please see my first comment which contains an instruction how to make the Excel work without a GUI session.

<div>
<div class="content wysiwyg-content">
I am trying to run .vbs script who reads data from Excel. It works fine when I run it from command line but it does not work if I run it from Task Scheduler, but if I run it as Administrators &nbsp;from Task scheduler it works. But the I can only save the task as &quot;Run only when user is logged on&quot;<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2019/11_w44/1435607/tasksk.PNG" target="_blank" title="file (18 KB)"><img alt="file" class="file-block lazyload" style="max-width: 646px;" data-src="https://filedb.experts-exchange.com/incoming/2019/11_w44/1435607/tasksk.PNG" /></a>
</div>
</div>


tasksk.PNG

I am trying to run .vbs script who reads data from Excel. It works fine when I run it from command line but it does not work if I run it from Task Scheduler, but if I run it as Administrators  from Task scheduler it works. But the I can only save the task as "Run only when user is logged on"



Run .vbs with Task scheduler

Batch files are text files containing a script of commands that are executed by the command interpreter on DOS, OS/2 and Windows systems. Most commonly, they are used to perform a series of functions that are repeated -- copying a set of files created daily with one step, for example.

Windows Batch

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.