Power Quary and VBA code

What do you want to achieve? You want to use VBA for excel I assume? It's possible to view  and change the content of a query or to create new queries. You can also Refresh tables based on a query. You cannot call VBA function from a query directly.

I had some good results with ChatGPT, but don't expect that to be first time right: You will still need to debug, simplify and understand the code yourself.