Powershell COM Object Disposal

I run into a strange issue with one of my Powershell scripts the other day, I was using an Excel COM object and I had an Excel process even after calling the objects Quit() function.

All the script was doing was to open an Excel xlsx file and save it as csv file. I could use the Get-Process and Stop-Process cmdlets be I would like to be able to schedule the script to run and not be afraid that it would kill any other Excel processes running at the same time.

After a few searches I found out that I could release the COM object with the following command:

[System.Runtime.Interopservices.Marshal]::ReleaseComObject($excel)

Here we are releasing the COM object excel using the Interopservices. Before doing this, make sure that you have saved your work done using the COM object.

Popular posts from this blog

Syslog Message Collection for OMS from sources that do not support the agent

How to Configure Message Forwarding on a Mailbox Level

Generating Alerts On OMS