VBA to delete connection with references

[jaryszek]

Hi Guys,

i am trying to delete connection "Table1" in VBA.
the problem is that i can delete even manually i am getting message:

Screenshot_217.png

my code is:

Please Login or Register  to view this content.

So my idea is to find all references through code and delete one by one in proper order.
How can i do this?

Best,
Jacek

[rorya]

Are you trying to delete the query or the connection? Your picture is the former but your code appears to be trying to do the latter.

[jaryszek]

Thank you Rory,

connection i tried. If this is connection only...

Best,
Jacek

[rorya]

Look at the picture and the error message. You were on the Queries tab of the pane, not the Connections tab, and the message said you couldn't delete the query as it was in use. What are you actually trying to do (and why)?

[jaryszek]

Ok Rory,

thank you. I do not have connections.
So i have to delete workbook queries instead of it!

Ok got it,
thank you,
Jacek

[jaryszek]

One more thing:

when i am trying to remove specific query:

Please Login or Register  to view this content.

i am getting error here: pq.Delete
Run time error: 9 - > object or variable not set.

Why if within loop works like a charm?

Best,
Jacek

[rorya]

You didn't use Set and you used pg not pq in the previous line.

[jaryszek]

Thank you!

Jacek