acExport : Excel Transfer « Excel « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Excel
  3. Excel Transfer

acExport

 

Private Sub cmdSalesSheet_Click()
    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryAllSalesFigures", "C:\Sales.xls"
End Sub








Related examples in the same category

1.acLink
2.Linking a Spreadsheet