Maybe the constant - #DEFINE XLSRCEXTERNAL 0 - should it be 4 ?
SourceType . 1 = xlSrcRange . 2 = xlSrcXml . 3 = xlSrcQuery . 4 = xlSrcExternal
-----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Alan Bourke Sent: Saturday, 14 June 2025 12:55 AM To: profoxtech@leafe.com Subject: Re: Automatic Excel Power Query CSV Import
On Fri, 13 Jun 2025, at 3:53 PM, Alan Bourke wrote:
Yeah, works OK from the command window. It adds the query string
Correction - it does NOT work OK from command window.