dear Master,


i have problem with my program,

scenario :

- i have one program to browse any file and path file will be place in Cell (Ex : Range("a1").
- Program two, will to import form text file.

problems :

how to change program two (in coding d:\for share\Engine Macro\Ms_Data\Loan_Microfinance2.txt) with call reference call path file in cell (Range("a1") ???

ex coding :

with ActiveSheet.QueryTables.Add(Connection:= _
"TEXT;d:\for share\Engine Macro\Ms_Data\Loan_Microfinance2.txt" _


thnx master,

sorry my English very bad .....