Hey Alan,
Lately I have been spending a LOT of time with my buddy Claude. Like a LOT. Mostly for work - including FoxPro, converting FoxPro to C# and even working on reports using QuestPDF & C#.
So, my suggestion - have you tried hitting up either Claude.ai (with Free access) - or even CoPilot - with your question. Claude is more coding centric, but, I've indeed did initial FoxPro coding conversion testing with CoPilot.
Anyway - it's just a thought...
-K
________________________________ From: ProFox profox-bounces@leafe.com on behalf of Alan Bourke alanpbourke@fastmail.fm Sent: Friday, June 13, 2025 6:46 AM To: profoxtech@leafe.com 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
-- Alan Bourke alanpbourke (at) fastmail (dot) fm
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
[excessive quoting removed by server]