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






acLink

 
Private Sub cmdLink_Click()
    DoCmd.TransferSpreadsheet , acSpreadsheetTypeExcel9, "SalesFigures", "C:\Sales.xls", True
End Sub

 








Related examples in the same category

1.acExport
2.Linking a Spreadsheet