I have a worksheet that pulls out the data from web directly through excel's "Get Data From web" functionality found on the Data tab - this part is now automated and automatically goes through a composed set of strings turned into a URL..
no this code automatically regenerates that web query and one problem I'm getting now is that the number of connections present in 1 workbook is so great that it appears it has reached its limit (i dont know how many is the limit - but this workbook has about 400 connections present).
so what i need now - is a macro that can Delete the web connections based on the name of the connection
(there is one i need to maintain - for the logins)
i went through the web for some search and tried recording. this came up
and somewhere in stack overflow they posted a code that loops through the queries but is referenced through the index, but what i need is the names![]()
Please Login or Register to view this content.
Bookmarks