title: trouble with 2010 save as dbf
body: <p>Below is the code I'm trying to fix. It works in Excel 2007 but not in Excel 2010.</p>
  
  <p>I believe it has to do with the XlDBF4 part. Please help.</p>
  
  <pre><code>Range("A1").Select
  ActiveWorkbook.SaveAs Filename:=Range("SetUp!L34") &amp; Range("SetUp!D28") &amp; "_" &amp; Range("SetUp!F28") &amp; ".dbf", FileFormat:= _
      xlDBF4, CreateBackup:=False
  ActiveWorkbook.SaveAs Filename:=Range("Setup!L28") &amp; Range("SetUp!D28") &amp; "_" &amp; Range("SetUp!F28") &amp; " " &amp; Range("SetUp!D30") &amp; ".xls", FileFormat:= _
      xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
      , CreateBackup:=False
  </code></pre>