title: VBA save Excel file as .xls from Access
body: <p>Hi,                                                                             I have to perform Import from Excel file into Access DB, without duplicates. Only way that this can be done is by creating table where you can Import Excel data, and then append It to destination table by buiilding a Query. Problem is that this Excel file has to be .xls format, none other format is working for me (don't know why). How can I do that from Access - desirable without opening Excel workbook, just change It's extension file name ? This is what I tried (I receive error : " object doesn't support this property or method")</p>
  
  <pre><code>Dim XFile As Excel.Application
  
  
  Set XFile = CreateObject("Excel.Application")
  XFile.Workbooks.Open "C:\Users\Mike\Desktop\Copy.xlsx", True
  
  XcelFile.SaveAs Filename:="C:\Users\Mike\Desktop\Copy.xlsx", FileFormat:=56
  XFile.Workbooks.Close
  
  End Sub
  </code></pre>
  
  <p>As you see, I need to save from .xlsx, It's default format for Excel 2013.</p>
  
  <p>Any help much appreciated !!</p>