title: How to open up a new Excel Workbook in MS Access VBA that's of the newer format?
body: <p>I am using MS Access and Excel 2010.</p>
  
  <p>In MS Access VBA, I create/open new workbooks like so:</p>
  
  <pre><code>Set objXl = CreateObject("Excel.Application") 
  Set xlWBk = objXl.Workbooks.Add
  </code></pre>
  
  <p>And despite having Excel 2010, for whatever reason this workbook only goes up to 65535 rows, I assume because for some reason it defaults to .xls when making a new book or something.</p>
  
  <p>It's only when I save as xlsx/close/reopen it do I get the full 1-million plus rows:</p>
  
  <pre><code>xlWBk.SaveAs someFilePath, FileFormat:=xlOpenXMLWorkbook 'xlsx format AFAIK
  xlWBk.Close
  Set xlWBk = objXl.Workbooks.Open(someFilePath)
  </code></pre>
  
  <p>Is there a way to default the creation of a new Excel workbook to be in .xlsx format with the full number of rows without needing to save/close/reopen it?</p>
  
  <p>Edit: In my case, changing the default save method in Excel's options doesn't seem to be sticking for whatever reason. New workbooks always want to open up in Compatibility Mode.</p>