none
Data Connections MS-EXCEL order RRS feed

  • Question

  • I have a lot of connections in one sheet of my EXCEL workbook. I want to control the order of refreshing connections. There is no option of setting order of refreshing connections. The only option is refresh all which refreshes all connection. Any ideas?
    Friday, October 21, 2011 7:37 PM

Answers

  • You can do this by going through them by coding each one of them seperately, for example:

    Sub RefreshConnectionWB()
    
    Range("H5").Select
    
    ActiveWorkbook.Connections("connection1").Refresh
    
    Range ("D5").Select
    ActiveWorkbook.Connections("connection2").Refresh
    
    'etc.
    
    End Sub
    

    Hope this helps,


    Daniel van den Berg | Washington, USA | "Anticipate the difficult by managing the easy"
    Saturday, October 22, 2011 5:49 AM
    Moderator