Forum Discussion

aekbus's avatar
aekbus
Brass Contributor
Jun 12, 2026
Solved

Excel Macro Creating a New Macro Enabled Spreadsheet

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.  Ho...
excel
Macros and VBA
  • MKoski's avatar
    MKoski
    Jun 12, 2026

    Afternoon AEKBUS,

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

MKoski's avatar
MKoski
Brass Contributor
Jun 12, 2026

Afternoon AEKBUS,

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

  • aekbus's avatar
    aekbus
    Brass Contributor
    Jun 12, 2026

    Thank you very much for your answer.  I knew it had to be a simple solution, but I am not very familiar with the vocabulary.