Browse 4 a file & disconnect a connection to external source

  • Thread starter Thread starter Faraz A. Qureshi
  • Start date Start date
F

Faraz A. Qureshi

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:\New 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!
 
Back
Top