title: How to keep the format of workbook after saving without affecting the Layouts(tables, color, styles)
body: <p>When some operation are done in workbook through VBA, and while saving it through VBA , the Tables, Clolors and Charts were not coming when i am trying to open the saved file.<br>
  i have created a chart for data from some workbook and it is working.<br>
  But if i save or saveas the workbook which has Chart, when i try to open again, no charts and tables and colors applied to some rows were not displaying, only plain data is displaying.  </p>
  
  <p>Source workbook is in .csv format.
  I am saving it as .xlsx and .csv.  </p>
  
  <p><code>ActiveWorkbook.SaveAs "C:\Documents and Settings\Desktop\finaloutput11.csv"</code><br>
   <code>ActiveWorkbook.Close SaveChanges:=True</code>   </p>
  
  <p>or<br>
   <code>ActiveWorkbook.SaveAs "C:\Documents and Settings\Desktop\finaloutput12.xlsx"</code><br>
   <code>ActiveWorkbook.Close SaveChanges:=True</code><br>
  tried with only save option too.  </p>
  
  <p>Please tell how to keep the format too.</p>