I have an AddIn with a function that selects a Table (in this case a BOM table) programmatically using SelectByID2 and the Name the table, followed by "@Sheetx". For example:
oExtension.SelectByID2("myMEWorksBOM@Sheet2", "ANNOTATIONTABLES", 0, 0, 0, False, 0, Nothing, 0)
It will not select the table once it is split, even though it reports the same Name.
Remove the Split and it will select it again...
I assume splitting the table into pieces adds some sort of prefix/suffix to the Name string, but I can't find any documentation on what it might be.