Hey dave that is the website that I got my macro from.
So actually im not sure if thats gonna help me out any more
But thanks though. Any other ideas??

"Dave Peterson" wrote:

And then I'd look at Chip Pearson's sample code:

http://cpearson.com/excel/ImpText.aspx

N.F wrote:

Why Im I getting an error in the partial code below??
Im trying to import a tezt file, but when I try to run it it highlights the
FName line and says the following messege: "Expected: line# or label or
statement or end of statement"

FName= F:\trial2.txt For Input As #1
Open FName For Input Access Read As #1
........................
........................
........................

Thanks in advance

--

Dave Peterson