Excel Macro Creating a New Macro Enabled Spreadsheet

Question

I have a macro enabled spreadsheet.&nbsp; I have a macro in this spreadsheet that is trying to create another macro enabled spreadsheet.&nbsp; I can create this new spreadsheet and save it as a .xlsm file.&nbsp; 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.&nbsp; My problem is that the only way I have found to name it is with SaveAs statement.&nbsp; If I could find out what name Excel assigned to this workbood when I created it, I could work with it - but I have not found a way to do that.If the above is confusing, I am sorry.&nbsp; In simple terms, I want my macro to create another macro enabled spreadsheet, name it, work with it and Save it without using SaveAs.I can provide code, but I thought I would start with this.

mkoski · Accepted Answer

Afternoon AEKBUS,&nbsp; &nbsp; &nbsp; &nbsp;Before you exit the newly created sheet, use a variable to get the active window caption (or workbook name) "V = ActiveWindow.Caption"&nbsp;

Forum Discussion

Excel Macro Creating a New Macro Enabled Spreadsheet

2 Replies