title: Save Excel sheet as html file similar to manual save as
body: <p>I have a multiple sheet Excel workbook. I want to save one sheet as a html file using VBA.</p>
  
  <p>It should be like the save as operation. When doing a manual save as the formatting is displaying in the saved HTML file. When using VBA the formatting is lost.</p>
  
  <pre><code>Application.Sheets("MNM Report").Activate
  ActiveSheet.Copy
  ActiveWorkbook.SaveAs Filename:="D:\Reports\09192014\mnm.html"
  </code></pre>
  
  <p>How to do this functionality with out losing the formatting?</p>