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

Domain Controller Machine Password Reset

Configuring a Certificate on Exchange Receive Connector

Running Multiple NGINX Ingress Controllers in AKS