Browse 4 a file & disconnect a connection to external source
 

I have a macro written to import data from some specific text files. How to
select such files for their full path as in:

With ActiveSheet.QueryTables.Add(Connection:="TEXT;F:\N ew Folder\CRF
MBGL.TXT", Destination:=Application.InputBox("Where Should The Data Be
Placed?", Type:=8))

And after obtaining the data I want the connection to be broken and data
remained static.

Any help obliged.

Thanx in advance!

--
Best Regards,

Faraz

Browse 4 a file & disconnect a connection to external source
 

Browsing matter resolved. However, how to have the connection broken?
--
Best Regards,

Faraz


"Faraz A. Qureshi" wrote:

I have a macro written to import data from some specific text files. How to
select such files for their full path as in:

With ActiveSheet.QueryTables.Add(Connection:="TEXT;F:\N ew Folder\CRF
MBGL.TXT", Destination:=Application.InputBox("Where Should The Data Be
Placed?", Type:=8))

And after obtaining the data I want the connection to be broken and data
remained static.

Any help obliged.

Thanx in advance!

--
Best Regards,

Faraz