Excel Macro VBA- How to save as xlsm with a filename based on date and cell value
<p>I really liked the solution <a href="https://stackoverflow.com/questions/12111491/force-save-as-xlsm-while-maintaining-file-structure?newreg=f2854e39749549b4934934dc6264d49d">here</a> that provided VBA that to force save as an xlsm file. Keeping in mind that I barely know anything about VBA, how could I modify this code to do the following:</p>

<ul>
<li>continue to force save as xlsm</li>
<li>file name equals the value of cell C1 in a sheet named "REPORT" + the text "BSC" + the date in YYYY.MM.DD format</li>
</ul>

<p>Any help would be greatly appreciated.</p>