Forum Discussion

jbarrett5g's avatar
jbarrett5g
New Contributor
8 years ago

How to get an object reference to an existing instance of Excel?

Hello, our AUT allows users to open a spreadsheet by clicking on a button/link. I'm trying to automate the validation of this function.  So after the button is selected, I want to get an object refe...
Manfred_F's avatar
Manfred_F
Regular Contributor

Thanks so far.

Now, I  tried to quit the Windows Task, but it didn't work correctly:

The application window disappeared, but in the Task list, the Excel Task remained there.

The same is Happening, when I send Alt-F4 keys to the window.

It seems to be a common Problem to terminate Excel via vbScript.

 

How could I kill the Excel Task f´rom the Windows tasklist?

AlexKaras's avatar
AlexKaras
Champion Level 3
8 years ago

Hi,

 

Use .Terminate() to kill the task.

However, if you are working with Excel through UI and OLE simultaneously, then I would recommend:

-- Set all COM references to Excel/workbooks/sheets/etc. to null in your code (syntax depends on used script language);

-- With JScript/JavaScript you may also call GC.Collect(); to force garbage collection;

-- Try to close Excel UI via ExcelProcess.Close(); call

-- Wait for some time to give Excel a chance to exit.