VBA using range properties for "connection only" table from PowerQuery

Hi,

I have a table loaded in PowerQuery as Connection Only.

Instead of exporting query as table and then using it in VBA, I want to know if it is possible to refer to the query table in VBA if it is connection only?

How would you achieve this in VBA by referring to range for connection only tables?

Thanks.