title: Changing Excel worksheet name in VBA
body: <p>I need to change the worksheet "USS IWO JIMA" with textbox data, in other words the name of the sheet should come from a textbox.  I tried but cant do it</p>
  
  <pre class="lang-vb prettyprint-override"><code>Set objApp = New Excel.Application
  'This is new 'Your excel spreadsheet      file goes here
  Set objBook = objApp.Workbooks.Add(strTemplatePath)
  'Name of sheet you want to export to
  Set objApp = objBook.Parent
  Set objSheet = objBook.Worksheets("USS IWO JIMA")
  </code></pre>