When creating this script, the thing that I struggled with the most was saving my workbook and cleaning up the COM object. I based my script on a solution that I found here.