Error when updating Power Query connections through VBA code

[DHero]

So, when going to the "Data" tab, selecting consults and connections and mannually updating the connections they work flawlessly, but when (after recording a macro doing these actions) running a couple lines of code that do this action it throws an error message "[DataFormat.Error] Esternal table is not in expected format".
Line of code: ActiveWorkbook.Connections("Consult").Refresh
Can somebody help make this work?

 

[dave3009]

Have you got other workbooks open? Reason I ask is you're using "ActiveWorkbook", which is a bit broad. Try to be more explicit and use "ThisWorkbook" and see if that helps.