Browse 4 a file & disconnect a connection to external source

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel file linked to external source 0
User Select File on Import External Data 3
Get External Data 10
Link to database 2
Imported text file to begin from the first empty cell 3
The Great Gatsby- Importing multiple external data files 6
help with ActiveSheet.QueryTables.Add Connection: 1
Problems importing data from a *.dat file 1

Top