Exporting Access data to Excel

• • Reply

  14 years ago

  by enzom

  Enzo Calcagno

  Montreal, Canada, Canada

  Joined 15 years ago

  In an Access form I have a button to export data from a query to an Excel file:

  Dim objExcel As DAO.Recordset
  DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Req_ImportALlToExcel", "C:\File.xls"
  

  It creates an Excel file with the proper data.  My question is what to do to open it at the same time without exiting Access?

   

  Thanks

  Report abuse