| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using another .xslx file as an external source (and how to update) | Excel Discussion (Misc queries) | |||
| Connect & disconnect dial-up connection inside Excel Vba | Excel Programming | |||
| External excel file for pulldown list source | Excel Worksheet Functions | |||
| External workbook links don't update when source file changes | Excel Worksheet Functions | |||
| Excel 2007/Vista: Missing file name on import external data connection | New Users to Excel | |||
Linear Mode
