Using an excel scope output variable to save as a new workbook

[Charles_Norman_US_AS (Charles Norman)]

Hello,

The issue I am having seems quite simple. I take in an excel shell/template and use the scope to clean the workbooks various sheets so that I can output the workbook variable that I have named Cleaned_Shell. I then run some sql queries that result in tables that need to be pasted into the template. I would like to be able to call the cleaned template variable (existing workbook) and write the results from the sql queries into that workbook, and then save that new workbook as a file with a new name.
The problem is that I can’t take in the variable as an existing workbook while still using the WorkbookPath to have it create the new file with a new name. The only way I can do it at the moment is to just write over the shell and then go in and save the shell as the name I want.

Thank you in advance for your help!