Forum Discussion
Power Quary and VBA code
Hi How to connect VBA code in Data Query Please give an exampe Thank you
Theoretically, this is possible, but there is a problem: when the power query plug-in is started, VBA will be blocked or unable to execute commands (especially in the same instance and the same file).
Possible implementation method: Use VBA to build a network service, Power Query sends a request to it (using Web.Contents), and the service performs operations based on the request content (but may be blocked or unable to execute commands).