How to unlock the file being connected to, after the data connection is not needed anymore using Excel VBA?

My goal is to actually update the Excel file using a data connection, then cut the file off after update in case there is a need to update the file being connected to, then reactivating the data connection before closing the file for the next session.

A suggestion was:

Private Sub DisableConnections()
    Dim conn As Object
    For Each conn In ActiveWorkbook.Connections
        conn.ODBCConnection.EnableRefresh = False
    Next
End Sub

But still locked the file that was being connected to by my Excel file.