Hi
Following on from this thread Loop through Power Query Connections adding them as table to new XL Worksheet - Page 2 (accessforums.net) where we were able to create tables from connections.
However, the flaw is that the table doesn't appear to have a meaningful connection behind it.
This means that although the data loads first time round, when you change the source data and refresh the table, the new data does appear in Power Query, but does not copy across to the Excel table.
I believe this is because the routine fails to create a meaning Connection behind the table.
In Data / Connections, all we see is an entry named Connection ...
Can anyone help with how to create a table from a connection, WITH the corresponding connection ? (Apologies for such poor description - not sure how else to put it)
I recorded a macro, where I manually 'Load To', in order to create a table and this will refresh when the source data changes.
This also has a more meaningful name in Data / Connections - something like Query - Connection to QueryName
However I am not able to parameterise this from an array of pre existing connection names.
As advised this is a new thread specific to the connection rather than just the tables.
Day three now .. this is hurting