Batch edit connections VBA

eduzs

Active Member
Joined
Jul 6, 2014
Messages
454
Hi there.

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

Code:
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.
 
Last edited by a moderator:

Forum statistics

Threads
1,086,235
Messages
5,388,623
Members
402,127
Latest member
Jemx

Some videos you may like

This Week's Hot Topics

Top