I got a "method OpenText of object Workbooks failed" runtime error.

I saw similar posts to mine. But, I did not see a solution. Strange.
The command works in Excel 97. If I use the user interface and bring in
a text file in manually it works. But, Excel 2002 can not handle
OpenText.

I don't know if the problem is XP or Excel 2002. And I need a solution
quick cause I am under a tight deadline.