Excel Macro Creating a New Macro Enabled Spreadsheet | Microsoft Community Hub (opens in new tab)

I have a macro enabled spreadsheet. I have a macro in this spreadsheet that is trying to create another macro enabled spreadsheet. I can create this new spreadsheet and save it as a .xlsm file. However, I want to give this spreadsheet a name and transfer data to it by toggling between my two sheets (Windows(Filename).Activate) and not save it until I am done. My problem is that the only way I have found to name it is with SaveAs statement. If I could find out what name Excel assigned to this ...