Automatic Excel Power Query CSV Import

Any Excel automation mavens in the audience? I'm trying to automate what Excel does when you do 'Get Data' from Text\CSV via PowerShell. I've recorded that process as a macro and the code in the linked Gist is attempting to replicate the macro VBA.

However no matter what I do it throws a 1426 COM error '800a03ec: Unknown COM status code' when attempting to add to the Workbook ListObjects collection.

https://learn.microsoft.com/en-us/office/vba/api/excel.listobjects.add

Probably something stupid - can anyone see any issue with the code ?

https://gist.github.com/AlanPBourke/091e4aa607239fa69d5f544e31bc958b