Yeah, works OK from the command window. It adds the query string correctly into the Workbook queries, it's something to do with adding a named Table that pulls from the query.

If the worst comes to the worst I can just inject the data into the sheet with ADODB ...

--

Alan Bourke

alanpbourke (at) fastmail (dot) fm

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox

OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech

Searchable Archive: https://leafe.com/archives

This message: https://leafe.com/archives/byMID/fe4ad217-a41b-488a-a4d5-4e9275c8035b@app.fastmail.com

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.