Import CSV file and problems with breaking external data link

[moradisndat]

Using Excel 2007. Having a few problems. I need to make a workbook that will automatically import a log file and present a few different charts to choose from. A user form will present options to view charts, print, email and save as pdf. I'm using FileDialog(msoFileDialogFilePicker) and QueryTables.Add to import CSV file. I noticed a growing list of entries in workbook connections and ExternalData in Name Manager. It was adding one each time I opened the workbook. I thought it had something to do with the parameters in the QueryTables.Add statement. So I experimented with changing them around a bit but that didn't help.

The other problem is when the file is imported and I try to convert it to a table, I get a pop-up msg about "selection overlaps one or more external data ranges." So I tried copying the imported data and paste special "values only" to a different area of the worksheet and deleting the original. Didn't work.

Found some code snippets online to remove connections and break external links. One of them works to remove connection but "External Data" is still showing in Name Manager. I've been reading the help files and still unable to figure it out. And here's the thing that has me totally confused. I just read something in the application help menu that says the "Edit Links" command on the "Data" tab is unavailable if my file does not contain linked information. Edit Links is grayed out in my application, yet I see something in workbook connections and name manager. (please see attached image)

How do I break the links to external data so that I can convert the imported data to a table?




Also, does the query table.add statement look ok? (attached image)



Any help is greatly appreciated. Thank you for your time.

 

[rahulismyname]

For breaking the links, just delete any name ranges that has been created and are being linked to other data sources. You can do that by going into the Name manager and selecting and deleting all. Let me know if that works and solves the issue.

 

[moradisndat]

For breaking the links, just delete any name ranges that has been created and are being linked to other data sources. You can do that by going into the Name manager and selecting and deleting all. Let me know if that works and solves the issue.

Thanks for your reply. I know about deleting the links in name manager and connections tabs and have been doing so as I continue to test each time I modify the code. I need to know how to do it programmatically with VBA in the module. This is supposed to be automated so that it runs smoothly for the user who will be importing the log files.