IIRC that's a pretty generic automation error code. One thing I recall from when I was doing more COM stuff was that VFP could lose track of object references particularly inside loops. Your code doesn't seem to be doing that sort of thing but that's my first thought.
Have you tried trying to do this interactively from the VFP command window? Generally speaking I would prototype COM stuff in the command window until I got things almost exactly perfect. 😊
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Alan Bourke Sent: Friday, June 13, 2025 6:47 AM To: profoxtech@leafe.com Subject: 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