Batch edit connections VBA

[eduzs]

Hi there.

I want to edit the connections of the activeworkbook doing something like:

Dim oCon

For Each oCon In ActiveWorkbook.Connections
  oCon.Refresh BackgroundQuery:=False
Next oCon

The code above does not works. How can I do that?
Thanks!


EDIT: Better explain: I want to disable the checkbox "Allow background refresh" in connection properties.