CSV import connection not renaming?

[Rudi]

Hi,

Any idea why the connection does not rename based on the code?
At the end of the import, I want to break the connection (delete it) so there is no reference to the source CSV file. By default the connection name is based on the csv file name, but this can change by month, so how does one delete the connection if I cannot rename it to a static name?

TX

1B.jpg

[HansV]

You don't need to know the name of the connection. You can delete it at the end of the With ... End With block:

Code: Select all

        ...
        .TextFileTrailingMinusNumbers = True
        .Refresh BackgroundQuery:=False
        .Delete
    End With
End Sub

[HansV]

Oh, and by the way: the line

Code: Select all

        .Name = "SourceData"

does not set the name of the connection, but of the imported range.

[Rudi]

TX for both those details. Important to know and working now...