title: SaveAs FileFormat argument in Excel isn't version-dependent
body: <p>Starting in Excel 2007 it is recommended that you provide a <code>FileFormat</code> argument to the <code>Workbook.SaveAs</code> command because even if you specified a .xls filename but without a <code>FileFormat</code> argument, it will make the file corrupt and unable to be read in Excel 2003 since the newly saved file will take the format of the ActiveWorkbook (which would be 2007).</p>
  
  <p>In order to save in Excel 2003 compatible format, it is suggested to use these following <code>FileFormat</code> values:
  -<strong>4143</strong> if in Excel 2003 and  <strong>56</strong> in Excel 2007 as so:</p>
  
  <pre><code>If Val(Application.Version) &lt; 12 Then
    ' You use Excel 97-2003
    FileExtStr = ".xls": FileFormatNum = -4143
  Else
    ' you use excel 2007 or later
    FileExtStr = ".xls": FileFormatNum = 56
  End If
  </code></pre>
  
  <p>However i tried using <strong>-4143</strong> regardless if the executing client was Excel 2003 or 2007 and it worked fine. Can anyone confirm if this is the case?</p>
  
  <p>Source: <a href="http://www.rondebruin.nl/saveas.htm" rel="nofollow">Use VBA SaveAs in Excel 2007-2010</a></p>