Forum Discussion
zwie
4 years agoFrequent Visitor
Reuse query connection for new sheet
Hello, I am running power queries from VBA and am having issues reusing my old connections. I am working in a system where we need to delete and recreate the output sheet each time so I can't jus...
Anonymous
4 years agoNot applicable
Hi zwie ,
I am working in a system where we need to delete and recreate the output sheet each time
So are the columns in the VBA always the same?
Hope these could help:
VBA Macro to Create Power Query Connections for All Tables - YouTube
Modifying Power Query M code with VBA - Excel UnpluggedExcel Unplugged
Best Regards,
Eyelyn Qin