Hi All,
I am writing a macro that collects data from many different http addresses on our intranet. This however leaves me with a lot of connections, that slows excel after a while. How can I delete these connections ? I create the connection as shown below.
Please Login or Register to view this content.
I have tried "" with no effect.Please Login or Register to view this content.
Last edited by Amdi; 01-28-2013 at 09:40 AM.
Hi Amdi,
The forum rules stipulate that if you show code in your post you must do so using CODE tags. Please edit you post, select the code and click on the # button.
If you like my contribution click the star icon!
Sorry about that. It has been corrected.
Hi Amdi,
No probs.
Try deleting the QueryTable as opposed to the connection
Hi OllieB
Thanks, that worked. with your advice and a little help from google I found the below to remove the tables.
I also stumbled over the method below, that also can solve this issue.Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks