Linking a Spreadsheet : Excel Transfer « Excel « VBA / Excel / Access / Word






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

Linking a Spreadsheet

 
Sub link()
     DoCmd.TransferSpreadsheet acLink, acSpreadsheetTypeExcel9, _
            "SalesFigures", "C:\Sales.XLS", True
     MsgBox "Spreadsheet linked"
End Sub








Related examples in the same category

1.acLink
2.acExport