+ Reply to Thread
Results 1 to 3 of 3

Delete connection after importing csv file into worksheet.

  1. #1
    Forum Contributor
    Join Date
    11-03-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    246

    Delete connection after importing csv file into worksheet.

    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.


    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    https://www.youtube.com/watch?v=sQIImQbEO_Q

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: Delete connection after importing csv file into worksheet.

    Try add one line
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    11-03-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    246

    Re: Delete connection after importing csv file into worksheet.

    jindon Thanks for the response, I couldn't get that to work. I have found a solution now. Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Change Connection File for a Data Connection
    By manofcheese in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-30-2015, 03:49 PM
  2. Replies: 2
    Last Post: 05-15-2015, 04:12 PM
  3. Activex connection problems, connection jumps if a second Excel file is opened.
    By rdl201 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-30-2013, 09:45 AM
  4. Importing a .txt file without saving the connection, using VBA, possible?
    By azureriders in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-14-2012, 01:56 PM
  5. Importing Text File and Updating Excel Worksheet
    By sebastianfrench in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2009, 06:40 PM
  6. VBA Importing .tsv file to worksheet
    By tpdawson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2009, 03:40 AM
  7. Excel 2007 data connection not using connection file
    By algilstrap in forum Excel General
    Replies: 0
    Last Post: 06-09-2009, 03:01 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1