Data refresh error excel connections SQL query

(0) Share

Report

Posted on by Prabhu_Rajaram

hello experts, i know this is not related to power platfrom, but i really need some experts help with my issue.

I have created connection in excel using SQL query, and i have dynamic query in my Excel Cell (this will be dynamic and will be updated based on the slicer options i created).

all i just wants to run the query based on the dynamic query refers from excel cell. below is the VBA code i used to refer the query and refresh the connection to run. But i get some run-time error "Application-defined or object-defined error" code runs correctly till the line "Sheet1.Select", but it throws error while executing the yellow highlighted line.