Results 1 to 1 of 1
  1. #1
    3 Star Lounger
    Join Date
    Nov 2011
    Location
    Australia
    Posts
    221
    Thanks
    80
    Thanked 3 Times in 2 Posts

    Data Connection build up "fix", Macro

    I found this macro elsewhere, it seemed to fix a problem with the build up of Data Connections I never knew there were so many. Counted up 9 figures long in some cases. Deleting all one by one or even doing Shift-Arrow Down key to select more took forever to do to.
    And it's in most, if not, all of my workbooks!

    So this "fix" saved not just the day, the rest of the year deleting these Data Connections in Excel 2010

    Code:
    Sub delete_Connections()
    Do While ActiveWorkbook.Connections.Count > 0
    ActiveWorkbook.Connections.Item(ActiveWorkbook.Connections.Count).Delete
    Loop
    End Sub

  2. The Following 2 Users Say Thank You to XPDiHard For This Useful Post:

    Maudibe (2013-07-22),RetiredGeek (2013-07-23)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •