title: Excel VBA Copy a Range into a New Workbook
body: <p>I am a newbie to <code>Excel VBA</code>.</p>
  
  <p>I am trying to copy a range of data from worksheet output into a new excel workbook and save the new workbook with the the value in E3.</p>
  
  <p>As a bonus, I would love to be able to also copy the data into <code>wordpad</code> and save as E3.xml</p>
  
  <p>Here is the <code>VBA</code> I have thus far:</p>
  
  <pre><code>Sub CopyOutput()
  Dim myname As String
  mystring = E3
  Dim myselection As Range
  
  myselection = Sheets("Output").Columns("F").Select
  Set NewBook = Workbooks.Add
      With NewBook
          .SaveAs Filename:="C:\Program Files\White Plume\Scenarios\" &amp; myname &amp; ".xls", FileFormat:= _
               xlsx, CreateBackup:=False
      End With
  myselection.Paste
  End Sub
  </code></pre>