[Ask] Import Text file And Call reference path file with Value Range.

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 .....

I'm not familiar with the quertytables function but in my experience with dynamic filepaths i usually have to put it in a variable. I'm not sure if this will work in your case but its worth a shot right?

Please Login or Register  to view this content.

Originally Posted by GaidenFocus

I'm not familiar with the quertytables function but in my experience with dynamic filepaths i usually have to put it in a variable. I'm not sure if this will work in your case but its worth a shot right?

Please Login or Register  to view this content.

thx brother i will try and report to you