Close linked imported text file

[jcorlando]

I'm a bit stuck on this one.

I've imported data from a text file into Excel using the below code.
where sFullName is the full path and name of the file.

When I go to save the data back to sFullName,
I get an error message indicating the file is still open.

How can I close the file after importing the data?

Here's the code:

    '-- Import the Text File ----------------------------------------------
    With ActiveSheet.QueryTables.Add(Connection:="TEXT;" & _
                                     sFullName, _
                                     Destination:=wsData.Range("$A$1"))
        .Name = sName
        .FieldNames = True
        .RowNumbers = False
        .
        .
    End With

Thanks,

John
In Annapolis, MD

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showthread.php?t=582769

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).