Hi, I created this code Statements_Import_CSV with the macro recorder to import a csv file into my worksheet, all works fine.
In the video (link listed below) he includes code (also listed below) to delete the connection to the csv file after importing because the connections list will just keep growing. My code to import the csv differs in that I will only need to import 1 file each time I use it.
My issue is; I do not know which lines of code I am missing to make the code to delete the connection work!
Your help would be greatly appreciated. Thank you.
https://www.youtube.com/watch?v=sQIImQbEO_Q
Bookmarks