Error -2146777998 at creating excel file

[WWolf78]

Hello Together,

for a test device I'm creating an excel file.

sometimes I get the following Error:

from debugging I know, this happens here:

Working solution is to end the Excel Task via the Taskmanager:

is there a way to do this within the program as I'd like to reduce User interaction..

Thanks

[Defaphe]

Hello,

By using the Report Generation Toolkit it works well even if Excel is already open and in use.

An other way is to kill the task with System Exec, as you are doing manually currently.

[WWolf78]

Hi defaphe,

thanks for the Tip.

I tried the following, but it doesn't work.

Error occurs at the "workbooks""add"

the termination is ok, but again at the "add workbook" the error happens again and the excel Task is still running

so obviously the termination of the excel task does not work

any ideas why:?

[WWolf78]

even the full path name does not work:

[Defaphe · Accepted solution]

You are missing some "". See the snippet below.

 

[WWolf78]

damn, always those tiny details which blocks those functions...

with the "" it works!

Thanks!