title: Get Excel sheet name and use as variable in macro
body: <p>I'm trying to find a way to use an Excel sheetname as a variable in a macro that I've written. Every month I deal with a workbook that is sent to me with 2 sheets. Part of the macro uses the 'Open File' interface to navigate to the folder and open the file. </p>
  
  <p>The first sheet in the file is called 'Report', which is static. All I do with that is delete it (because I don't need it). </p>
  
  <p>The second sheet could be called anything and that's the sheet upon which I need to run the macro. Is there a way to say:</p>
  
  <pre><code>shtName = %whatever_the_sheetname_is_called%
  </code></pre>
  
  <p>and then use the 'shtName' variable throughout the macro? I suppose getting this new filename as a variable would help as well. </p>