Ok, this is going to be one of the dumber questions you see here. I am trying to write a little script that will export stuff from SQL Server to an existing Excel 2013 workbook into multiple ...

Given you're using SQL Server 2008 R2, are you able to use SSRS? This supports exporting to Excel and other formats.