title: How to export a specific sheet from my workbook to separate workbook?
body: <p>I am trying to export a specific sheet in the workbook to a separate workbook(.xlsx).</p>
  
  <p>I can export as PDF.</p>
  
  <p>Here is the relevant part of the code:</p>
  
  <pre><code>On Error Resume Next
  Kill ("D:\MAT.pdf")
  On Error GoTo 0
  
  With Sheets("MAT")
     .ExportAsFixedFormat Type:=xlTypePDF, Filename:="D:MAT.pdf", OpenAfterPublish:=False
  End With
  </code></pre>
  
  <p>The purpose is to attach it in an email, which I did successfully, but I want to be able to attach it as an Excel sheet.</p>
  
  <p>Notes:</p>
  
  <ul>
  <li>Can the sheet be exported without being a "macro-enabled sheet"?</li>
  </ul>