Reading Text File into Excel and match the first part with placing the value in 2 nd part
Posted by Andrew Cheung on August 05, 2001 8:25 AM
I have a text file like this:
011235461 1023.00 2226.65
I have the code "123456" in [A1]
How could I read the contents "1023.00" into [b1] and "2226.65" into [c1]
and then the other code and so on?
(the code in column A is in random order but the code in the text file is in ascending order)
Anything like Looping through the cells.
(CInt() is useless as the code is a 6-digit number and it causes the Overflow problem"