Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. AcExport
Private Sub cmdSalesSheet_Click()
    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryAllSalesFigures", "C:\Sales.xls"
End Sub