Hello rjj920,
This macro will remove them. Add a New VBA module to your workbook and paste this code into it. You can run the macro using the ALT+F8 while in Excel to bring up the macro dialog.
Sub RemoveConnections() Dim qt As Object For Each qt In ActiveSheet.QueryTables qt.Delete Next qt End Sub
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thanks, Leith. I am still having a hard time reestablishing the connection to pull that same file and generating a new report (i.e. when I remove the connection 0418.csv and then rerun my macro to repull the new 0418.csv file, I get the cannot connect error). I'm hoping there is an easy way to generate new connections automatically without too much hassle.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks