Search results

Ok, I've found the solution. The property is read-only so you have to delete the original linked table and recreate with the new worksheet name. Here's the code in case anyone else has the same problem: Sub RecreateLink(sCurrName As String, sSheetName As String) Dim tdfNew As TableDef...

Unfortunately I've tried that but I get the error I mentioned in my original post.

Hi, I've got a database with many linked tables (from Excel workbooks with multiple worksheets). Recently the names of the worksheet tabs in the source data has changed. I want to update the linked table definition to refer to the new names without having to delete/recreate them. I can't...