In MS Access I made a link to an excel workbook, via VBA, with the following command:
DoCmd.TransferSpreadsheet acLink, acSpreadsheetTypeExcel12Xml, "link", "C:\Users\mike\Desktop\bim2024.xlsx", True, "Sheet1$"
Now I need to remove that link via another command in VBA but I don't know how to do it.
I tried with .remove but it didn't work
DoCmd.DeleteObject acTable, "YourLinkedTableName"
will get you there.