You’re offline. This is a read only version of the page.
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.
CodeString = picks the updated query from Sheet2.Range("A1")
Below is the code from Sheet2, this is dynamic, will be changed as required.
Share
Report
All responses (
Answers (
404
