Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Linking a Spreadsheet
Sub link()
     DoCmd.TransferSpreadsheet acLink, acSpreadsheetTypeExcel9, _
            "SalesFigures", "C:\Sales.XLS", True
     MsgBox "Spreadsheet linked"
End Sub